Skip to Content.
Sympa Menu

freetds - Re: Adding Strings with quote's in?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Mark Schaal <mark AT champ.tstonramp.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: Adding Strings with quote's in?
  • Date: Fri, 11 Feb 2000 10:40:39 -0800 (PST)



I belive you want to double up that single-quote.

INSERT INTO test VALUES( 'The Wolve''s are coming' );

Mark

>
> Obviously, an
>
> INSERT INTO test VALUES( 'The Wolve's are coming' );
>
> Isn't going to cut it, so I used PHP's "AddSlashes" function, which does the
> equivalent of:
>
> INSERT INTO test VALUES( 'The Wolve\'s are coming' );
>
> Which it doesn't seem to like either...
>
> Any suggestions? - Is there a problem doing this with FreeTDS? (We have
> another system running MySQL which I do manage to use AddSlashes to protect
> embedded quotes etc. in field data with)...
>
> Thanks,
>
> -Karl

--
Mark J. Schaal Phone: (909) 620-7724
TST On Ramp Fax: (909) 620-8174
System Administrator E-Mail: mark AT tstonramp.com




Archive powered by MHonArc 2.6.24.

Top of Page