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

It looks like the sybase magic quotes option is my salvation. It turns all POST and GET variable exchanges on the fly from '' to ' and vice versa... Thanks for all of the great suggestions everyone. John --------------------- John Asendorf - jasendorf@lcounty.com Web Applications Developer http://www.lcounty.com - NEW FEATURES ADDED DAILY! Licking County, Ohio, USA 740-349-3631 The benefit to the government of replacing all $1 Federal Reserve notes with $1 coins would be $522.2 million per year, according to estimates of the General Accouting Office released on April 7, 2000. > -----Original Message----- > From: Andrian Pervazov [mailto:apervazov@aspen-marketing.com] > Sent: Monday, February 05, 2001 5:16 PM > Cc: php-windows@lists.php.net > Subject: Re: [PHP-WIN] Converting apostrophes for insertion > into Oracle > > > For SQLServer and Oracle, the single quote is escaped by simply > repeating it. You can dio it by hand, but I believe this is what the > sybase magic quotes directive does as well. > > Andrian > > Christopher Derr wrote: > > > > I'm working on this same issue with my, don't laugh, Access > 97 backend. When > > users enter apostrophes into the field, it chokes on them. > I've been using > > urlencode and urldecode and that converts everything > happily but makes looking > > directly at the database entries painful: > > > > Let%5C%27s+test+apostrophes > > > > is actually Let's test apostrophes. Urldecode works it out > on the web end. > > > > I would imagine there are scripts to get the apostrophe's > out, but magic_quotes > > (from the PHP.ini file) and addslashes doesn't seem to do > the trick... > > > > Chris > > > > "Asendorf, John" wrote: > > > > > 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 > > > > >> AJ> FEATURES ADDED 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 > > > > > > > > > > > > > > > -- > > > 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 > > -- > 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 >