Re: Passing multiple select statements to MySQL

2014-02-20 Thread SSC_perl
On Feb 19, 2014, at 4:20 AM, Dr.Ruud wrote: > my $sth_4; > ... > (untested) Thanks for the code but I still get the same error: DBD::mysql::st execute failed: You have an error in your SQL syntax; - Long pause for trial and error -- Well with the help of the auth

Re: Passing multiple select statements to MySQL

2014-02-19 Thread Dr.Ruud
On 2014-02-18 02:27, SSC_perl wrote: I'm helping someone retrieve some info from a MySQL db and I'm having trouble sending multiple select statements with Perl. Here's a portion of the code: use SQL::SplitStatement; my $query_4 = "CREATE TEMPORARY TABLE `temp_ip` AS (SELECT `ip` F