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 - [EMAIL PROTECTED]
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:[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 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:[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 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
> > > > >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 - [EMAIL PROTECTED]
> > > > >> AJ> Web Applications Developer
> > > > >> AJ> http://www.lcounty.com - NEW 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: [EMAIL PROTECTED]
> > > > >> For additional commands, e-mail: 
> [EMAIL PROTECTED]
> > > > >> To contact the list administrators, e-mail:
> > > > >> [EMAIL PROTECTED]
> > > > >>
> > > > >
> > > > >--
> > > > >PHP Windows Mailing List (http://www.php.net/)
> > > > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > >For additional commands, e-mail: [EMAIL PROTECTED]
> > > > >To contact the list administrators, e-mail:
> > > > >[EMAIL PROTECTED]
> > > > >
> > > >
> > >
> > > --
> > > PHP Windows Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail: 
> [EMAIL PROTECTED]
> > 
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: 
> [EMAIL PROTECTED]
> 
> -- 
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: 
> [EMAIL PROTECTED]
> 

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to