Re: DBI Query insert issue....

[kennethk]

in reply to DBI Query insert issue....

You could manually escape your inputs using quote (as described in DBI), but that's still a lot of interpolation and kind of a mess. Cleaner would be to use Placeholders and Bind Values. For example, if I were writing your code, it might look more like

my $sql = <<EOSQL;

insert into Table ( Ticket_ID,
                    Subject,
                    Status,
                    Priority,
                    Created_Time,
                    Queue,
                    Owner,
                    Class_Type,
                    Sent_Date)
values (?,?,?,?,?,?,?,?,now());

EOSQL

my $query = $dbh->prepare($sql) or die $dbh->errstr;
$query->execute($Ticket_ID,
                $Subject,
                $Status,
                $Priority,
                $Created_Time,
                $Queue,
                $Owner,
                $Class_Type,
               ) or die $dbh->errstr;

Also note I corrected a typo in your SQL - in the future, make sure that what you post actually compiles/runs/demonstrates your issue, as described in How do I post a question effectively?.

[SriniK]

Hi

Thanks for replying...
I thought i have given enough information about my problem.
Anyway with ur answer i have solved my problem

Thanks
Srinivasan

[kennethk]

You did give enough information in this case, but errors in posted code frequently act as red herrings, where people trying to help get confused about what's actually at issue. As well, if posted code doesn't display exactly the errors reported, many potential helpers will skip your issue. Such an error can also be inadvertently copied into a suggested solution, resulting in difficulties. And finally, I have frequently found that the act of coming up with my example code to post tracks down exactly the issue I needed help with.