Can't you just set the sql for your query as a string and enclose it? e.g <cfset sql = "Select foo from bar where field1 = 'foo' and field2 = 'bar'>
<cfquery name="blah" datasource="blahblah"> #PreserveSingleQuotes(sql)# </cfquery> -----Original Message----- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 8:26 PM To: CF-Talk Subject: preservesinglequotes() for entire query? Is there an easy way to stop an entire cfquery from automatically quoting each variable? I would normally use preserveSingleQuotes(), but I have a query where I need to do it for every variable and was wondering if there is an easier way? jon ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
