List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 1 2003 4:50am
Subject:Re: Next issue: Can't execute multiple statements?
View as plain text  
In the last episode (Apr 30), TheMechE said:
> 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;

Send four separate queries (or upgrade to mysql 4.1).  Even with 4.1, I
recommend sending four queries, because that way you can error-check
each statement.
 
-- 
	Dan Nelson
	dnelson@stripped
Thread
Next issue: Can't execute multiple statements?TheMechE1 May
  • RE: Next issue: Can't execute multiple statements?Jennifer Goodie1 May
    • Re: Next issue: Can't execute multiple statements?Mark Matthews1 May
RE: Next issue: Can't execute multiple statements?TheMechE1 May
  • Re: Next issue: Can't execute multiple statements?Dan Nelson1 May