Adding Strings with quote's in?
francis at oztel.com
Fri Feb 11 19:49:51 EST 2000
Karl Pielorz wrote:
> Hi All,
> OK - We've now got PHP + FreeTDS + SQL V7 to talk quite nicely to each
> other... The problem I'm stuck with now is how to insert the following text
> into a database field...
> The Wolve's are coming
> Obviously, an
> INSERT INTO test VALUES( 'The Wolve's are coming' );
you need to insert
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...
there doesn't appear to be a function of this sort yet,
maybe if I find the time I'll write text2SQLServertext,
hopefully with a better name.
> 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)...
no this is a MS-SQL Server prob, or rather a prob with their SQL, I used to get
this with ASP before I moved to PHP.
> You are currently subscribed to freetds as: francis at oztel.com
> To unsubscribe, forward this message to $subst('Email.Unsub')
Grisly . oo
Knowledge By Design/OzTel
Suite 201, 683 George st
Sydney 2000 NSW
mailto:francis at kbd.com.au
Tel: +61 2 9212 1399
Fax: +61 2 9212 5727
m$: How can we stuff you up today?
More information about the FreeTDS