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


_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to