0

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?

2
Contributors
2
Replies
5
Views
3 Years
Discussion Span
Last Post by MaddTechwf
0

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>
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.