[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    RE: Next issue:  Can't execute multiple statements?
From:       "TheMechE" <TheMechE () microneil ! com>
Date:       2003-04-30 18:55:48
[Download RAW message or body]



Scenario 1.

I build String.  I pass to execute() Here is the results...

All from my log writer
20030430.145301 Delete from Licenses where LicenseID = 269;Delete From
LicenseRules Where LicenseID = 269;Delete from Categories where categoryID
IN (-1) ;Delete from LicenseSlaves where MasterID = 269 OR SlaveID = 269;

20030430.145301 java.sql.SQLException: Syntax error or access violation: You
have an error in your SQL syntax. Check the manual that corresponds to your
MySQL server version for the right syntax to use near ';Delete From
LicenseRules Where LicenseID = 269;Delete from Cat

When I pass the same string to my StringTokenizer ( and split on ";") to do
the update and
perform each step one by one it works.





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]