Hi there,
Try this
<%
dim objconn, objrs
dim sqltxt, criteriatxt, adopenkeyset, adlockoptimistic
adopenkeyset=1
adlockoptimistic=3
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, adopenkeyset, adlockoptimistic
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
%>
Hope this helps
---------------------------------------------------------------------
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
