Multiple Line SQL for MySQL?

Frank D. Engel, Jr. fde101 at fjrhome.net
Wed Mar 23 11:06:54 EST 2005


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

No clue for MySQL, but I can tell you that it definitely supports 
multi-line SQL commands with PostgreSQL, while the docs tell you that 
it may not support them for all database types.  MySQL may not support 
this (my understanding is that the database server will need to have 
support for it, as Rev itself does not parse the statements -- can 
anyone confirm?)


On Mar 23, 2005, at 6:45 AM, Peter Reid wrote:

> Does anyone know whether Rev supports multiple-line SQL command 
> execution with MySQL?
>
> I have a Rev 2.5.1 project that is trying to create and populate a new 
> database based on an existing template database.  I have used 
> phpMyAdmin to dump a SQL script to a text file from a template 
> database containing the SQL commands to construct all the tables and 
> data I require.  However, I can't find a way of sending this script to 
> MySQL using Rev? (I can read the file into a text container, but I 
> can't feed this to the MySQL server using the revDB support commands 
> and functions).
>
> If I use revExecuteSQL command (or equivalent function revdb_execute), 
> I can send a single SQL command only.  If I try to use this inside a 
> "repeat for each..." loop to work through a text object that contains 
> multiple commands, then I hit a problem with any commands that have 
> been laid out across several physical lines (as you get from 
> phpMyAdmin dumps!).
>
> I really don't want to have to parse the SQL dump statements myself 
> and convert each long multi-line command into a long single-line 
> command just so I can use revExecuteSQL!  Nor do I want to use a 
> shell() command as this is a client-server application with the code 
> running on a client and the MySQL server running on a server on the 
> same local network.
>
> Any suggestions please?!
>
> Peter
> -- 
> Peter Reid
> Reid-IT Limited, Loughborough, Leics., UK
> E-mail: preid at reidit.co.uk
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
- -----------------------------------------------------------
Frank D. Engel, Jr.  <fde101 at fjrhome.net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten 
Son, that whosoever believeth in him should not perish, but have 
everlasting life.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFCQZQe7aqtWrR9cZoRAuOCAJ4wVQwT6Ma8BEjpZfM3o3XeMMib+QCdFdhD
D+OIWPrYMbejAUG4ox4AXMc=
=Q1j6
-----END PGP SIGNATURE-----



___________________________________________________________
$0 Web Hosting with up to 200MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com



More information about the Use-livecode mailing list