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

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 …
Jump to Post

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 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.