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. _______________________________________________ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard
