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?

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.