dear all,
when i want to find some records in mysql table using ASP script language, i
found an error on it.
this is error message in my script:
Microsoft OLE DB Provider for ODBC Drivers error '80040e29'
The rowset cannot scroll backwards
/find_record.asp, line 16
and this is my ASP script:
<%
dim objconn, objrs
dim sqltxt, criteriatxt
set objconn = server.createobject("adodb.connection")
set objrs = server.createobject("adodb.recordset")
objconn.connectionstring="server=192.168.0.1;driver=MySQL;db=clientdb;uid=us
er;pwd=user"
objconn.open connectionstring
sqltxt = "select * from client"
criteriatxt = "name like 'TELE*'"
objrs.open sqltxt, objconn
objrs.find criteriatxt
if objrs.eof then
response.write("record is not exist!")
else
response.write objrs("code") & " " & objrs("name") & " " &
objrs("address") & "<br>"
end if
objrs.close
objconn.close
set objrs = nothing
set objconn = nothing
%>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
