mySQL disconnects

[stephen barncard]

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 <bobsneidar at 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 <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
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>