cgastacks
March 17th, 2002, 19:09
Response.Write("<table>")
Response.Write("<tr><td>")
Response.Write("<a class='oAColumn'>Science Fiction</a><br>")
While not oRS.EOF
Response.Write("<a class='oACSub' href='ncgarev.asp?ID=")
Response.Write(oRS(sSQL= "SELECT ID FROM Film WHERE 'Science Fiction'"))
Response.Write("'>")
Response.Write(oRS("Title"))
Response.Write("</a><br>")
oRS.Movenext
Wend
Response.Write("</td></tr>")
Response.Write("</table>")
I get an error of:
Item cannot be found in the collection corresponding to the requested name or ordinal.
/webpub/nlayout.asp, line 34
MSDN has it listed as
Error number 3265; adErrItemNotFound; Item cannot be found in the collection corresponding to the requested name or ordinal. An incorrect field or table name has been specified.
Any help would get appreciated thanks in advance.
Response.Write("<tr><td>")
Response.Write("<a class='oAColumn'>Science Fiction</a><br>")
While not oRS.EOF
Response.Write("<a class='oACSub' href='ncgarev.asp?ID=")
Response.Write(oRS(sSQL= "SELECT ID FROM Film WHERE 'Science Fiction'"))
Response.Write("'>")
Response.Write(oRS("Title"))
Response.Write("</a><br>")
oRS.Movenext
Wend
Response.Write("</td></tr>")
Response.Write("</table>")
I get an error of:
Item cannot be found in the collection corresponding to the requested name or ordinal.
/webpub/nlayout.asp, line 34
MSDN has it listed as
Error number 3265; adErrItemNotFound; Item cannot be found in the collection corresponding to the requested name or ordinal. An incorrect field or table name has been specified.
Any help would get appreciated thanks in advance.