One thing to try is to run your variables through PreserveSingleQuotes()
before you do the query, i.e.

<cfset PSQvariable = PreserveSingleQuotes(variable)>

<cfquery>
insert into blah(var)
values('#Trim(PSQvariable)#')
</cfquery>

Sounds odd, yes... but I've had troubles like that in the past and that's
what worked.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to