multiple lines SQL request via revdb_execute ?
jbv.silences at club-internet.fr
Thu Jun 19 05:49:35 CDT 2008
Thanks for the fast reply.
> Hi JB,
> I don't think it is possible to send multiple-line MySQL syntax.
That's a real pity; even more when you realize that it's possible in phpMyAdmin...
> Do you have a loop in your locally running stack, which calls the Rev
> CGI in a loop, or do you have the loop in your Rev CGI script? This
> would make a big difference, because the latter is much faster than
> the former.
actually my problem is strictly limited to cgi scripts.
Here's an exemple of what I'd like to do :
put "UPDATE myTable SET N = N+1 WHERE id = 1;" &cr into myREQ
put "UPDATE myTable SET N = N- 10 WHERE id = 5;" after myREQ
put revdb_execute(theID, myREQ) into tQueryResult
I've thought of using some php code that I'd call from the Rev cgi script via a
shell call, but the msec I'd gain by sending a multiple-line mySQL request would
be lost during the shell call... [sigh]
JB (quite frustrated)
> Best regards,
> Mark Schonewille
> Economy-x-Talk Consulting and Software Engineering
> Benefit from our inexpensive hosting services. See http://economy-x-talk.com/server.html
> for more info.
> On 19 jun 2008, at 12:14, jbv wrote:
> > Hi list,
> > I think I've already posted a similar question long time ago (couldn't
> > retrieve it
> > in the archives though) but didn't get any answer AFAIR...
> > Anyway, here I go again : has anyone succeeded in sending a multiple
> > lines
> > SQL request to mySQL via revdb_execute ?
> > I've tried any possible syntax I could think of (requests separated by
> > semicolons
> > and/or line returns, etc) but nothing seems to work...
> > And I haven't found anything in the doc...
> > Any idea if that's possible or not ? It would be great if it was
> > possible, because
> > when using Rev cgi with mySQL, and especially multiple successive
> > requests in
> > loops, cgi scripts can get slowed down dramatically...
> > Thanks in advance,
> > JB
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the use-livecode