Re: find record using MYSQL command in ASP

2002-07-07 Thread Ivan Paul
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

RE: find record using MYSQL command in ASP

2002-07-07 Thread Defryn, Guy
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=

find record using MYSQL command in ASP

2002-07-07 Thread Ivan Paul
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 scrip