> > [TCX][MyODBC]Lost connection to MySQL server during query
> >
> > Can someone suggest a painless way to reconnect to MySQL in this case?
>
> Wrap the call in a try/catch block that retrys till it works.
Ugh, so I'd have to do that for all my queries? Lame.
I was hoping for something more along the lines of <CFQUERY
TIMEOUT="NEVER">, or something nice-n-simple like that..
Hm, so I'd have to wrap the query itself in something like?
<CFLOOP CONDITION="notQ">
<CFSET notQ=false>
<CFTRY>
<CFQUERY/>
<CFCATCH TYPE="ANY">
<CFSET notQ=true>
</CFCATCH>
</CFTRY>
</CFLOOP>
Hrmph. There isn't a more elegant way to regain lost connections to MySQL?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
