Member Avatar for abolbridge

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
  • 129 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by abolbridge
Member Avatar for abolbridge

never mind I found the problem.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.