From: | "Ken Wills" <gfccall(at)mailbag(dot)com> |
---|---|
To: | <pgsql-interfaces(at)hub(dot)org> |
Subject: | RE: [INTERFACES] RE: your mail (Should have been problems with ') |
Date: | 1998-11-23 15:58:48 |
Message-ID: | 000d01be16fa$28bc0b80$211f46c6@kpw.gfc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-interfaces |
>>
>> >$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 '.
>Have you tried doing:
> print STDERR ${inputstr}, "\n";
>To see what your 'insert into...' string looks like exactly? It looks
>like you are missing a ' in there somewhere when you are generating yoru
>string...
I tried this, and can see whats causing the error. From apache's error log:
--snip--
\'
\'
\'
none7
[Mon Nov 23 09:54:31 1998] [error] DBD::Pg::db do failed: ERROR: Bad datetime external representation
'Mon Nov 23 09NULLNULL 1998'
--snip--
the time field is the last one to go in here. the insert string looks like:
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')};
It seems like I am getting an extra \' from somewhere. I'll take a look at that. Thanks again to all.
Ken
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-11-23 17:31:12 | RE: [INTERFACES] RE: your mail (Should have been problems with ') |
Previous Message | The Hermit Hacker | 1998-11-23 15:35:34 | Re: [INTERFACES] RE: your mail (Should have been problems with ') |
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-11-23 17:31:12 | RE: [INTERFACES] RE: your mail (Should have been problems with ') |
Previous Message | david | 1998-11-23 15:52:46 | Dereferencing PG_Result |