my $ins_rec="INSERT INTO $table (symbol,valuation_dt,expn_dt,strike,open,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'});