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
