mySQL disconnects

[Bob Sneidar]

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 <bobsneidar at 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