Might anyone know the cause of the following problem & hopefully a solution. Below is an excerpt from the mysqld.log file, 95% of the time this is working correctly but on occassion the UPDATE statement is being passed incorrectly through the JDBC driver. There should be 2 UPDATE statements being passed as shown below but somehow they are being mixed into one at times. Both are results of the same code.

I am using the mm.mysql.jdbc-1.2c JDBC driver

Any help would be greatly appreciated, Thanks, Derek.....

CORRECTLY BEING PASSED

------------------------

11548 Query select * from meta_address where personid=1546 11548 Query UPDATE meta_audit SET status ='P',date_received = 0 WHERE personid = 1546 AND status = 'H' 11548 Query UPDATE meta_audit SET date_received = NULL WHERE personid = 1546 AND email_no = 1 11548 Quit

ERROR in SQL STMTS BEING PASSED

--------------------------------

2610 Query select * from meta_person where personid=5257?emailno=1 2610 Query UPDATE meta_audit SET status ='P',date_received = 0 WHERE personid = 5257?emailno=1 AND status = 'H'

****************************************************************************