Sorry about this. Yes, <cfquery param> did the trick.

__________________________________
Daniel Farmer
Producer / Coldfusion Developer
http://www.bernardclark.com/danfarmer.ca
P: 613.284.1684



>From: "Philip Arnold" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: problem with french characters when updating MSSQL.
>Date: Mon, 19 Apr 2004 17:55:07 -0400
>
> > From: Dan Farmer
> >
> > I have the following being input into a MSSQL longtext....
> > I've tried several functions such as "preservesinglequotes"
> > and "paragraphformat" but I still get errors... any ideas
> > as to what string function I should be using?
> >
> > It seems to be choking on the french characters.
>
>First off, is the field a nText or nVarchar?
>
>Secondly, what happens when you use CFQUERYPARAM?
>If you're not using it, why not?
>
>Thirdly, what version of CF?
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to