> it might be best to ask this in the cf forums, however did > you try to separate the statements with a ; ? I haven't tried > 2 query statements for MySQL in cfquery...yet ;-) Also I > believe MySQL 3.23+ supports @@identity
Yes I've tried semicolons after the statements, and I've tried setting autocommit = 0 at the beginning also. I will ask on a CF list, because they may have run into this issue. But really I think it's a MySQL question. Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]