multiple lines SQL request via revdb_execute ?

[Mark Schonewille]

Hi JB,

I don't think it is possible to send multiple-line MySQL syntax.

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.

--
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