From: Ken Wills <gfccall@mailbag.com>
To: Pgsql-Admin (E-mail) <pgsql-admin@postgreSQL.org>
Date: Mon, 23 Nov 1998 07:38:02 -0600
Message-ID: <000401be16e6$7ee24600$211f46c6@kpw.gfc.net> (raw)
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@gflesch.com
Phone: 1-888-4325556
Fax: 1-608-2222432
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: gfccall@mailbag.com, pgsql-admin@postgreSQL.org
Subject: Re:
In-Reply-To: <000401be16e6$7ee24600$211f46c6@kpw.gfc.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox