PDA

View Full Version : whats wrong with this asp?



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.

Cyber
March 17th, 2002, 19:28
i would check this line:


Response.Write(oRS(sSQL= "SELECT ID FROM Film WHERE 'Science Fiction'"))