Re: MySQL DBI an Socket::IO dropping inserts somewhere

If the debug print (print DEBUGFILE "$sqlStatement\n" if $DEBUG;) shows the query as expected (as I'm understanding you), then it's unlikely that the IO::Socket part has anything to do with the problem. In other words, I'd focus on the DB side, and enable tracing to figure out what happens (or doesn't)...

BTW, where are you setting $usingDB? (I suspect it's some global setting, but you don't show where you set it...) In case of doubt, put the debug print within the if ($usingDB) { ... } where the actual submission to the DB is supposed to happen.

Comment on Re: MySQL DBI an Socket::IO dropping inserts somewhere Select or Download Code

Replies are listed 'Best First'.
Re^2: MySQL DBI an Socket::IO dropping inserts somewhere by whiteonline (Novice) on Oct 17, 2009 at 14:18 UTC
Thanks for the link to tracing. I am reading up on it now. I will take your advice and concentrate on the DB side of things; I'll reply back with any tracing discoveries. Also, you are correct, `$usingDB` is a global set in the beginning of the script. I've seen stranger things; printing it out is a great tip. Cheers!	[reply] [d/l]