ADODB.Field error '80020009'

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 423,490 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,723 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ASP advertiser: Lunarpages ASP Web Hosting

Thread Tools Display Modes

Views: 648 | Replies: 1 | Solved

•

Join Date: May 2008

Posts: 2

Reputation: abolbridge is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

abolbridge abolbridge is offline

Offline

Newbie Poster

ADODB.Field error '80020009'

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