Hi,
I have been trying to read data from a hash and put it into myaql using insert into statement.


foreach $key (keys %submt_feat)
{
   if($submt_feat{$key}){
        $submt_feat{$key}= $submt_feat{$key};
        push(@sbft,$key);
        push(@sbval,$submt_feat{$key});
   }
}
$temfeat = "(".join(",",@sbft).")";
$temval = "(".join(",",@sbval ).")";
$ins = "insert into submitter ";
$statement = $ins.$temfeat." values ".$temval.";";
$statement = $dbh->prepare($statement);
$statement->execute();

but it doesnt work because the values need quotes around them since its varchar type.
i am not able to get quotes around them. This is very urgent and I will really really appreciate any ideas.
Thank you,
Kaustubh


_________________________________________________________________
Studies, career, romance. Whatever your concerns. http://www.astroyogi.com/newMSN/ We have the answers.




Reply via email to