ON-THE-FLY FILTERS

Have you tried the following? SELECT tblY.fldX FROM tblY #PreserveSingleQuotes(SESSION.F)#; > CF8 > > SELECT tblY.fldX > FROM tblY > WHERE tblY.fldA='something'; > > That works okay. But I want to set the WHERE clause on-the-fly. So the > user selects the filter (via a form) and the result is stored as > <cfset SESSION.F = "WHERE tblY.fldA='" & FORM.Result & "'"> (where > FORM.Result = something) > > Do a cfoutput to check SESSION.F and that shows WHERE tblY. > fldA='something'    All is well. > > So, my code is > > SELECT tblY.fldX > FROM tblY > #SESSION.F#; > > The problem is, it now displays as > > SELECT tblY.fldX > FROM tblY > WHERE tblY.fldA="something"; > > And that throws an error. Why does SESSION.F display correctly in the > cfoutput but CF8 changes the ' to " when I use it in cfquery ?