multiple lines SQL request via revdb_execute ?

[jbv]

Hi Mark,

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]

Best,
JB (quite frustrated)

>
> --
> Best regards,
>
> Mark Schonewille
>
> Economy-x-Talk Consulting and Software Engineering
> http://economy-x-talk.com
> http://www.salery.biz
>
> 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: