Thanks Barney...I had a feeling there was something like that out there, but wasn't sure where to look

>Wrap your #mySQLString# in preserveSingleQuotes().  CF automatically escapes
>single quotes inside variables when they are output inside CFQUERY, because
>usually variables don't contain SQL, just values.  preserveSingleQuotes() is
>there for exactly this situation.
>
>Cheers,
>barneyb
>
>>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to