I'm working with a database that was setup before me. The column name is year. When I'm writing my SELECT string, I try referencing the year column and get NULL repsonses. How can code this correctly to reference the year column?

Recommended Answers

All 2 Replies

Hmmm...

If you use this sample code (within your open and close statments) which builds a generic table.., you dont get any data back from the query?

<table style="width:500px;">
  <tr>
  <%for each x in oRS.Fields
        Response.Write("<th>" & x.name & "</th>")
  next%>
  </tr>
  <%do until oRS.EOF%>
    <tr>
    <%for each x in oRS.Fields%>
      <td><%Response.Write(x.value)%></td>
    <%next
    oRS.MoveNext%>
    </tr>
  <% loop %>
</table>

That worked. Thank JorgeM.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.