Escaping single quotes in cfquery

[bhavanig]

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

[r937]

@bhavanig

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

three

[aaron_martone]

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

[bhavanig]

thanks