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 ? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351752 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
