--On Monday, May 06, 2002 19:43:06 +0000 David Bovill
<[EMAIL PROTECTED]> wrote:
> OK the way I'm doing it at the moment is to pipe SQL from MC into MySQL
> using the shell() command - not sure if there is a better way but this
> works without having to use php or another intermediate scripting
> language.
>
> function executeSQL someSql, mySqlHost, userName, password
> put "| mysql -h mySqlHost -u userName -p" & password into
> pipeToBatchMySQL put "echo '" & someSQL & "'" && pipeToBatchMySQL into
> mySqlShellCommand put shell(mySqlShellCommand) into buffer
> return buffer
> end executeSQL
>
> Any comments on how to improve this appreciated.
That's how I would do it...
>
>
> _______________________________________________
> metacard mailing list
> [EMAIL PROTECTED]
> http://lists.runrev.com/mailman/listinfo/metacard
>
Regards, Andu Novac
_______________________________________________
metacard mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/metacard
