From: | "Ken Wills" <gfccall(at)mailbag(dot)com> |
---|---|
To: | "Pgsql-Admin (E-mail)" <pgsql-admin(at)postgreSQL(dot)org> |
Subject: | |
Date: | 1998-11-23 13:38:02 |
Message-ID: | 000401be16e6$7ee24600$211f46c6@kpw.gfc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-interfaces |
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: gfchelp(at)gflesch(dot)com
Phone: 1-888-4325556
Fax: 1-608-2222432
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-11-23 14:11:02 | Re: your mail |
Previous Message | E Rajendran | 1998-11-23 13:37:16 |
From | Date | Subject | |
---|---|---|---|
Next Message | Edhi Nugroho | 1998-11-23 13:59:12 | Pgaccess 0.91, core dumped |
Previous Message | Andrey Silaev | 1998-11-23 12:23:00 | translation dll |