I've been told that RevChat is a good place to start… sqb
*--* *Stephen Barncard - San Francisco Ca. USA - Deeds Not Words* On Sun, Feb 2, 2014 at 11:47 AM, Bob Sneidar <bobsnei...@iotecdigital.com>wrote: > Reposting my own post. I am looking at the socket API for Livecode and > wondering if I can do something along those lines. Looks like I can > manipulate the socket timeout, so that is promising. > > One thing that concerns me is that the dictionary says that code execution > continues while the connection is being made, something I will have to > prevent as the whole point is establishing a viable connection *before* I > proceed. > > Does anyone have a simple example of how to use the socket API and wait > for a response? I know I could probably take a couple hours of trial and > error and figure it out, but frankly I am lazy. :-) > > Bob > > > On Jan 31, 2014, at 08:28 , Bob Sneidar <bobsnei...@iotecdigital.com> > wrote: > > > Hi all. > > > > I’m struggling with an issue (it may have been addressed before but I > cannot find it) where I am getting this error when attempting to query a > mySQL database hosted at on-rev: > > > > sqlyoga_executesql_err,0,0,Lost connection to MySQL server during query > (SELECT customers.custid, customers.customername, customers.industry, > customers.salesperson, customers.altid, customers.lastupdate FROM customers > WHERE customername = "Webcor Builders Inc”) > > > > Yes I am using sqlYoga but I was getting the same error before I started > using sqlYoga. It seems that the SQL server has some sort of timeout built > in where sessions are dumped. It takes a full minute for the query to fail. > I cannot subject end users to this kind of wait simply because they took a > long lunch. > > > > I need a way to test whether or not the current connection to the > database is still valid without invoking the 1 minute wait. Any suggestions? > > > > Bob > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
