Beste Defrin...
thank u very much my friend.
it is work! :D
Cheers...
----- Original Message -----
From: Defryn, Guy <[EMAIL PROTECTED]>
To: 'Ivan Paul' <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 08, 2002 10:38
Subject: RE: find record using MYSQL command in ASP
> 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
