Hi!
I have an annoying problem, that I just haven't been able to get around yet. When I
parse the
input from a form and go to insert it eveything works fine as long as the user doesn't
use
the ' character in the input. I've tried using qw{} and qq{}, which either don't
interpolate
or give me errors. Anyone have any suggestions? Postgres 6.4, Apache 1.3, mod_perl
1.16.
The insert statement is below.
my $query_string=qq{INSERT INTO CALLS (ca_service_id, ca_org_name, ca_phone_number,
ca_status,
ca_product, ca_problem, ca_resolution, ca_contact_name, ca_assigned, ca_date) VALUES
('$service_id',
'$org_name', '$phone_number', '$status', '$product', '$problem', '$resolution',
'$contact',
'$assigned', '$time_now')};
Thanks in advance.
Ken Wills
GFC Call Center
Email: [EMAIL PROTECTED]
Phone: 1-888-4325556
Fax: 1-608-2222432
