Hello mysql, I have been using MySql with php for quite some time. DB and app works quite well.
I now have to connect to MySql from a DB environment called OpenInsight. Not to bore you with the details but it is a 32bit windows environment whose primary database is a multi-dimensional db based on the 'PICK' model. The connection is through MyODBC (just downloaded newest version yesterday to be sure I wasn't seen a version problem). Selects work great .. The problem comes in during updates (I haven't tested against inserts) My app selects say .. 1-6K rows which it needs to change. Then it loops through the rows .. makes the change .. and simply updates the single field changed. The problem comes in that every other row fails with what is being reported and 'uncanceled query' (error 7). Of course if I then do the process again .. every other row again fails. Now this eventually works itself out .. sort of a binary update <G> At first I thought it was a timing issue. So I put a wait in the loop .. upto 10 seconds per row update .. we went from every other to every 8th. Any ideas what could be causing this. Is there a switch in the odbc or the myini that i have not correctly set? -- Best regards, Dtsig mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- 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
