Escaping the ' character

[sevex]

I'm trying to query an access database, and it won't let me use double quotations around my condition, but the condition has a ' character. how can I escape an apostrophe?

Thanks

 

[CFDude]

Have you tried wrapping it around a PreserveSingleQuotes function?

e.g

Where field = #PreserveSingleQuotes(myvar)#

 

[tleish]

Use a 2nd apostraphe to escape the first one:

SELECT * FROM TABLE
WHERE field = 'Can''t' - tleish

 

[sevex]

ohhh, why didn't I think of that. In the end I just assigned it to a variable and let coldfusion do it automatically

thanks again tleish