Hi Len,
Yes, if the server allows it, you can do all you describe. It is
indeed recommendable to use a cgi or irev to connect to MySql. I use
PHP for this. Many hosts, including yours sincerely, don't allow a
direct a connection to a database from a MySQL client.
Why would you put effort into keeping a connection alive? I don't
think that keeping a connection alive will increase transaction speed
significantly, unless you can connect to a database directly, without
cgi/irev/php.
You can write a cgi or php script, for instance, which interprets a
query from your client and executes it. I would consider this rather
insecure, because a hacker who finds out how to send queries gets full
control over your database.
You can get a url or use the post command to connect to a server and
send your query from your revlet the same way you can from a desktop
standalone.
Why is this complex?
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Software Engineering
http://economy-x-talk.com
Submit your software products to http://www.quickestpublisher.com and
get found!
On 9 aug 2009, at 18:43, Len Morgan wrote:
I'm trying to convert one of Tcl/TK programs to work on a web server
instead of the desktop. Because of the Sarbanes/Oxley Act, this
will save them a lot of money.
My question is:
I can convert the screens/tabs/menus fairly easily to a revLet. In
fact, this is going rather smoothly. The problem is that the data
to fill the fields comes from a SQL server. I assume that I'm going
to need some sort of .cgi/.irev program to send a query to and get
the results back from. Will this require a connect/disconnect every
time I need to get data? Can I create a generic cgi/irev program to
receive a query and return tab delimited records?
Better still, can I "connect" from my revLet and keep the connection
open and talk to the server directly from the revLet?
As I said in my subject, this is a much more complex use of the
revLet than I've seen talked about here.
Any help and/or advice would be appreciated.
Len Morgan
KTTK, Inc.
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
