| | |
ADODB.Field error '80020009'
Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
•
•
Join Date: May 2008
Posts: 2
Reputation:
Solved Threads: 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
<%
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
![]() |
Similar Threads
Other Threads in the ASP Forum
- Previous Thread: bonfire
- Next Thread: Validation vbscript to ASP
| Thread Tools | Search this Thread |
archive asp asp.net aspandmssqlserver2005 aspandmssqlserver2005connection aspconnection connection database databaseconnection dreamweaver excel fso iis msmsql mssql2005 mssqlserver2005 mssqlserver2005andasp mssqlserverandasp opentextfile record searchbox selectoption single specfic sqlserver sqlserverconnection windows7





