jbv.silences at club-internet.fr
Fri Aug 17 03:16:10 CDT 2007
I'm trying to squeeze more than one SQL commands into 1 single
request in a Rev cgi script.
For instance :
UPDATE myTable SET N = N + 1 WHERE id = 1 LIMIT 1 ; UPDATE myTable
SET N = N + 1 WHERE id = 2 LIMIT 1 ;
I've tried all possible ways, like this one :
put "UPDATE myTable SET N = N + 1 WHERE id = 1 LIMIT 1 ; " into
put "UPDATE myTable SET N = N + 1 WHERE id = 2 LIMIT 1 ;" after
put revdb_execute(theID, myREQUEST) into tQueryResult
The first SQL command executes fine, but I get a syntax error message
from mySQL regarding the
2nd SQL command.
But when I paste the same set of 2 SQL commands into phpMyAdmin, then it
Any idea of what I could be missing ?
The doc doesn't mention any limitation regarding the SQLQuery parameter
I'm using Rev cgi 2.5, mySQL 4.0.15 and phpMyAdmin 2.6.0
More information about the use-livecode