From: | "Ken Wills" <gfccall(at)mailbag(dot)com> |
---|---|
To: | <pgsql-interfaces(at)hub(dot)org> |
Subject: | RE: your mail (Should have been problems with ') |
Date: | 1998-11-23 14:45:32 |
Message-ID: | 000601be16ef$eccb64e0$211f46c6@kpw.gfc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-interfaces |
Firstly, thanks to everone who replied so fast!!
> 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.
>escape your imput strings first...something like:
a number of people suggested something like:
>$phone_number =~ s/'/\\'/g;
Ok, I tried this - it does what it looks like is supposed to. If I enter:
John's shoes, I get John\'s shoes. Unfortunatly I still get an error. If i enter it
as John's shoes' ,I dont get an error. Seems like it only likes them in pairs. The funny thing is if
I supply them in pairs, it inserts the whole string, I'd have thought that it would parse them
or something, and only insert the values between the '.
Ken
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Wills | 1998-11-23 15:16:25 | RE: [INTERFACES] RE: your mail (Should have been problems with ') |
Previous Message | The Hermit Hacker | 1998-11-23 14:11:02 | Re: your mail |
From | Date | Subject | |
---|---|---|---|
Next Message | postgres | 1998-11-23 15:10:48 | |
Previous Message | The Hermit Hacker | 1998-11-23 14:11:02 | Re: your mail |