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: [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,