Received: from glacier.binc.net (glacier.binc.net [205.173.176.10])
	by hub.org (8.9.1/8.9.1) with ESMTP id IAA20541
	for <pgsql-admin@postgreSQL.org>; Mon, 23 Nov 1998 08:37:42 -0500 (EST)
	(envelope-from gfccall@mailbag.com)
Received: from kpw (msn-1-33.x2.binc.net [198.70.31.33])
	by glacier.binc.net (8.8.8/8.8.6) with ESMTP id HAA27014
	for <pgsql-admin@postgreSQL.org>; Mon, 23 Nov 1998 07:37:35 -0600
Reply-To: <gfchelp@gflesch.com>
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>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Importance: Normal

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