ADODB.Field error '80020009'

Thread Solved

Join Date: May 2008
Posts: 2
Reputation: abolbridge is an unknown quantity at this point 
Solved Threads: 0
abolbridge abolbridge is offline Offline
Newbie Poster

ADODB.Field error '80020009'

 
0
  #1
May 22nd, 2008
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
Reply With Quote Quick reply to this message  
Join Date: May 2008
Posts: 2
Reputation: abolbridge is an unknown quantity at this point 
Solved Threads: 0
abolbridge abolbridge is offline Offline
Newbie Poster

Re: ADODB.Field error '80020009'

 
0
  #2
May 22nd, 2008
never mind I found the problem.
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the ASP Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC