My Coding Methodology - Understanding The Madness And The Man Behind It
UPDATE user SET foo =
<cfqueryparam value=
"#..#"
cfsqltype=
"CF_SQL_BIT"
/>
WHERE is_active = 1
For Cut-and-Paste
UPDATE user SET foo = <cfqueryparam value="#..#" cfsqltype="CF_SQL_BIT" /> WHERE is_active = 1