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
