5 messages in com.mysql.lists.win32RE: UPDATE fonction from ACCESS/SQL ...
FromSent OnAttachments
webmaster16 Dec 2001 01:08 
webmaster117 Dec 2001 00:45 
Snowman17 Dec 2001 02:32 
Don McClimans17 Dec 2001 03:34 
Venu17 Dec 2001 11:32 
Subject:RE: UPDATE fonction from ACCESS/SQL server to MYSQL3.23 difference?
From:Don McClimans (dmcc@intielectronics.com)
Date:12/17/2001 03:34:59 AM
List:com.mysql.lists.win32

One cause of this problem is that you are using server side cursors, which MySQL does not support. Server side cursor is the default, so add

cn.CursorLocation = adUserClient

just before opening your connection.

Don

-----Original Message----- From: webmaster [mailto:webm@aerialmultimedia.com] Sent: Sunday, December 16, 2001 4:09 AM To: win@lists.mysql.com Subject: UPDATE fonction from ACCESS/SQL server to MYSQL3.23 difference?

Hi, could someone tell me if theres things I should know about the UPDATE command between ACCESS and MYSQL 3.23. I have scripts that were designed mostly for Access and MS sql server. When I use them with Mysql, infortunately, it seems Mysql have a problem with it. After checking around, it seems it's the UPDATE fonction that makes the problem Here is the error I get: 80040e21 An OLE-DB operation in multiple par have generated errors. CHeck all OLE-DB state value available. No job have been done.

and if someone want, here is my code: <% if request("Selected2") <> "" Then ID_oeuvrearray=split(request("ID_oeuvre"),",") Goldarray=split(request("Gold"),",") Silverarray=split(request("Silver"),",") Bronzearray=split(request("Bronze"),",") for i=0 to ubound(ID_oeuvrearray) if len(trim(ID_oeuvrearray(i))) > 0 then RS_bet_result.addnew RS_bet_result("ID_oeuvre")=trim(ID_oeuvrearray(i)) RS_bet_result("Gold")=trim(Goldarray(i)) RS_bet_result("Silver")=trim(Silverarray(i)) RS_bet_result("Bronze")=trim(Bronzearray(i)) RS_bet_result.update end if next response.redirect "Bet_bet.asp" end if %> I wish ti keep with MYsql, would version 4 would help? Thanks for any help

N. Riotor Aerial Multimedia Création multimédia http://www.aerialmultimedia.com Tel : 00 (33) 1 47 90 82 16 Fax : 00 (33) 1 47 33 80 70 Prtb: 06 12 05 86 99 27 bis rue de Chanzy 92600 Asnières France icq: 3186516