Escaping single quotes in cfquery

bhavanig · February 28, 2011, 5:00pm

how many ways can we escape the single quotes while using cfquery.

r937 · February 28, 2011, 5:59pm

three

aaron_martone · February 28, 2011, 6:02pm

My favorite use is PreserveSingleQuotes(). It’s a built-in function of recent ColdFusions that ensures that single quotes aren’t auto-escaped.

bhavanig · March 3, 2011, 3:31am

thanks