Re: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt ?

[Tony Gravagno]

The easy answer is to pretend you're doing this from a web page,
where the MP in LAMP is MySQL and PHP.  From there you have a
world full of answers rather than something U2-specific.  Note
that most shared hosts don't have a MySQL DBMS on the same system
as the HTTP servers.  They almost Always separate MySQL to a
different box for queries, so examples for how to do this are
plentiful.

So write a small PHP script that does what you need, copy/paste
from examples if required.  Then invoke the script with a simple
SH or ! to execute the script, passing in params.  Capture
the result with an Execute Capturing clause, or have the script
write data to a directory which you reference as a type 1 or type
19.

That's it.  This one is fairly easy - just think outside of the
MV box.

HTH
T

From: Manu Fernandes
 From Universe/linux, I'll execute a mySQL sql phrase. 
 mySQL is installed on a remote server.
 
 - What is the mysql-client to be installed beside 
 Universe ?
 - How to execute a sql-phrase from UV/BASIC 
 ? and capture the result !?

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt ?

[Kevin King]

To followup to what Tony said, we do this with PHP by creating a
JSON-formatted extract out of Unidata, then ftp it to the other
system, then use Apache to kick off a job to post the file into MySQL
and PostgreSQL.  Works like a champ for small to medium data sets.
For large datasets we do something significantly more complicated
using triggers and a publisher that publishes changes to the Unidata
files using the callHTTP interface to send data to a PHP script
running on Apache.

-Kevin
http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users