SriniK has asked for the wisdom of the Perl Monks concerning the following question:
Hi,
I have used the following code to insert in to DB
please help me on this.
thanks
Srinivasan
I have used the following code to insert in to DB
this code working fine for a time. But now its working if the subject($subject) contains a quote(') like $subject contain Can't get the Mail.$dbh->do("insert into Table (Ticket_ID,Subject,Status,Priority,Create +d_Time,Queue,Owner,Class_Type,Sent_Date) value (\'$Ticket_ID\',\'$Sub +ject\',\'$Status\',\'$Priority\',\'$Created_Time\',\'$Queue\',\'$Owne +r\',\'$Class_Type\',now());");
please help me on this.
thanks
Srinivasan
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: DBI Query insert issue....
by runrig (Abbot) on Jul 03, 2012 at 16:28 UTC | |
Re: DBI Query insert issue....
by kennethk (Abbot) on Jul 03, 2012 at 16:59 UTC | |
by SriniK (Beadle) on Jul 04, 2012 at 09:36 UTC | |
by kennethk (Abbot) on Jul 04, 2012 at 20:19 UTC | |
Re: DBI Query insert issue....
by sundialsvc4 (Abbot) on Jul 03, 2012 at 20:12 UTC |
Back to
Seekers of Perl Wisdom