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


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;">
  <%for each x in oRS.Fields
        Response.Write("<th>" & x.name & "</th>")
  <%do until oRS.EOF%>
    <%for each x in oRS.Fields%>
  <% loop %>

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, learning, and sharing knowledge.