MySQL form shell()

2002-05-07 Thread diskot123
Well I should mention that Revolution supports direct access to MySQL, ODBC, Oracle, and Valentina databases on all platforms. Tuviah Snyder ~ [EMAIL PROTECTED] Runtime Revolution Limited - The Solution for Software Development http://www.runrev.com/

MySQL form shell()

2002-05-06 Thread David Bovill
Does you have any scripts for connecting (+ running SQL) to a MySQL database? ___ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard

Re: MySQL form shell()

2002-05-06 Thread Michael Kann
On Windows98 I'm using the setup: Metacard/Xitami/PHP4/MySQL. If you are interested in a standalone solution (not on a network or over the Internet) an easy way to do it is to put your SQL statements in a file c:/windows/desktop/goodSQL.sql then type \. c:/windows/desktop/goodSQL.sql at the MySQL

Re: MySQL form shell()

2002-05-06 Thread David Bovill
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

Re: MySQL form shell()

2002-05-06 Thread andu
--On Monday, May 06, 2002 19:43:06 + 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