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

The error comes up when you have something like this INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES("$Max_ID", "$SHORT_NAME") and $SHORT_NAME is empty so the SQL looks like this INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES("20002", "") //doesn't work If I use the single quote or apostrophe, it works fine.... INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES('20002', '') //works fine > -----Original Message----- > From: Svensson, B.A.T. [mailto:B.A.T.Svensson@lumc.nl] > 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 attribute (filed). Or do I misinterpret the > error message? > > >-----Original Message----- > >From: Asendorf, John [mailto:JAsendorf@lcounty.com] > >Sent: Monday, February 05, 2001 10:21 PM > >To: Pablo Vera; Php-Windows (E-mail) > >Subject: RE: [PHP-WIN] Converting apostrophes for insertion > into Oracle > > > > > >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 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, 3:03:21 PM, John wrote: > >> > >> AJ> I've got a web form that might have someone entering > apostrophes. > >> AJ> Unfortunately, my SQL statement has apostrophes in it and > >> it seems to be > >> AJ> messing it up... > >> > >> AJ> Any suggestions other than a regex (which I could do myself)? > >> > >> AJ> John > >> > >> AJ> --------------------- > >> AJ> John Asendorf - jasendorf@lcounty.com > >> AJ> Web Applications Developer > >> AJ> http://www.lcounty.com - NEW FEATURES ADDED > >> AJ> DAILY! > >> AJ> Licking County, Ohio, USA > >> AJ> 740-349-3631 > >> > >> AJ> The benefit to the government of replacing all $1 Federal > >> Reserve notes with > >> AJ> $1 coins would be $522.2 million per year, according to > >> estimates of the > >> AJ> General Accouting Office released on April 7, 2000. > >> > >> > >> > >> -- > >> PHP Windows Mailing List (http://www.php.net/) > >> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > >> For additional commands, e-mail: php-windows-help@lists.php.net > >> To contact the list administrators, e-mail: > >> php-list-admin@lists.php.net > >> > > > >-- > >PHP Windows Mailing List (http://www.php.net/) > >To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > >For additional commands, e-mail: php-windows-help@lists.php.net > >To contact the list administrators, e-mail: > >php-list-admin@lists.php.net > > >