0

I keep getting this error and I can't figure out why. Here is my code:

<%
set conn = server.createobject("adodb.connection")
set rs = server.createobject("adodb.recordset")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("/data/newsleepermedia.mdb") & ";Jet OLEDB:database"

rs.open "select * from Prices WHERE id=" & request("idnum"),conn,3,3

if not rs.eof then
do while not rs.eof
response.write "There is a Match."
rs.movenext
loop
else
response.write "No matches."
end if
%>

And this is the link I use to link to the page:
http://www.sleepermedia.com/admin.asp?u=prices&idnum=<%=rs("id")%>&action=view

1
Contributor
1
Reply
2
Views
9 Years
Discussion Span
Last Post by abolbridge
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.