Re^10: MySQL INSERT in Perl

this is what I did, and it doesn't like it... I seem to run into problems using prepare/execute, and they seem to disappear when I use do

my $ins_rec="INSERT INTO $table (symbol,valuation_dt,expn_dt,strike,op
+en,bid,ask,last,volume) VALUES(?,?,?,?,?,?,?,?,?);";

     # print "my ins_rec is $ins_rec\n";
      my $sth=$dbh->prepare($ins_rec);
      $sth->execute(\'$h1{'symbol'}\',now(),\'$exp\',$h1{'strike'},$h1
+{'open'},$h1{'bid'},$h1{'ask'},$h1{'last'},$h1{'volume'});
[download]

Comment on Re^10: MySQL INSERT in Perl Download Code

Replies are listed 'Best First'.
Re^11: MySQL INSERT in Perl by baperl (Sexton) on Aug 04, 2011 at 22:45 UTC
and I fixed everything...I'm using placeholders and all works. THANKS guys!	[reply]