RE: [PHP-WIN] Converting apostrophes for insertion into Oracle

2001-02-06 Thread Asendorf, John
n April 7, 2000. > -Original Message- > From: Andrian Pervazov [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 5:16 PM > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-WIN] Converting apostrophes for insertion > into Oracle > > > For SQLServer and Oracle, the single

RE: Re[2]: [PHP-WIN] Converting apostrophes for insertion into Oracle

2001-02-06 Thread Asendorf, John
[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 6:06 PM > To: Php-Windows (E-mail) > Subject: Re[2]: [PHP-WIN] Converting apostrophes for insertion into > Oracle > > > John: > > You could do something like this (I'm not sure if this will work): > &

[PHP-WIN] Converting apostrophes for insertion into Oracle

2001-02-05 Thread Florian Clever
the quote when binding. Also you do not have to worry about LONG columns. Florian Von: Andrian Pervazov <[EMAIL PROTECTED]> Betreff: Re: [PHP-WIN] Converting apostrophes for insertion into Oracle CC: [EMAIL PROTECTED] For SQLServer and Oracle, the single quote is escaped by simply repeat

Re[2]: [PHP-WIN] Converting apostrophes for insertion into Oracle

2001-02-05 Thread Pablo Vera
attribute(?) >> (filed), not the >> content of the attribute (filed). Or do I misinterpret the >> error message? >> >> >-Original Message- >> >From: Asendorf, John [mailto:[EMAIL PROTECTED]] >> >Sent: Monday, February 05, 2001 10:21 PM

Re: [PHP-WIN] Converting apostrophes for insertion into Oracle

2001-02-05 Thread Andrian Pervazov
HORT_NAME) VALUES('20002', > > '')//works fine > > > > > -Original Message- > > > From: Svensson, B.A.T. [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, February 05, 2001 4:39 PM > > > To: Asendorf, John > > > Subje

Re: [PHP-WIN] Converting apostrophes for insertion into Oracle

2001-02-05 Thread Christopher Derr
> > > -Original Message- > > From: Svensson, B.A.T. [mailto:[EMAIL PROTECTED]] > > Sent: Monday, February 05, 2001 4:39 PM > > To: Asendorf, John > > Subject: RE: [PHP-WIN] Converting apostrophes for insertion > > into Oracle > > > &

RE: [PHP-WIN] Converting apostrophes for insertion into Oracle

2001-02-05 Thread Asendorf, John
ailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 4:39 PM > To: Asendorf, John > Subject: RE: [PHP-WIN] Converting apostrophes for insertion > into Oracle > > > That seams to be related to the name of the attribute(?) > (filed), not the > content of the attr

RE: [PHP-WIN] Converting apostrophes for insertion into Oracle

2001-02-05 Thread Asendorf, John
Hi Pablo To answer your question, yes... It doesn't seem to like that because the field can be empty... for some reason Oracle won't allow you to have an empty field enclosed by two "'s... ORA-01741: illegal zero-length identifier John > John: > > When you say that your SQL statement has a

Re: [PHP-WIN] Converting apostrophes for insertion into Oracle

2001-02-05 Thread Pablo Vera
John: When you say that your SQL statement has apostrophes, you mean single quotes enclosing a string value ?, if this is the case, why not try changing the single quotes in your SQL for double quotes. Saludos, Pablo _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Monday, February 05, 2001,

[PHP-WIN] Converting apostrophes for insertion into Oracle

2001-02-05 Thread Asendorf, John
I've got a web form that might have someone entering apostrophes. Unfortunately, my SQL statement has apostrophes in it and it seems to be messing it up... Any suggestions other than a regex (which I could do myself)? John - John Asendorf - [EMAIL PROTECTED] Web Applications