Setting a string = to a parsed cfstatement

[JakeFlynn]

I want to allow users of my website to define there own custom queries using a
form. The problem that i am running into is that cfset cannot handle this kind
of expression:

<cfset cust_sql = <cfoutput>select num, cust_code, entered_date, status,
assigned_to, contact,
synopsis, symptom_code, bus_name, priority, title
from info, customer
where
info.cust_code =customer.cust_code and
<cfif #site# is not "" and #site# is not "All">
cust_code in (#site#)
<cfelse>
cust_code in (select customer.cust_code from customer
where parent_id = '#Session.e_code#' or
cust_code = '#Session.e_code#')
</cfif>
and
searchable not in ('N','P') .......etc ></cfoutput>

I dont want it to save the actual coldfusion statements just the output after
they have been parsed. Anyone have anyideas?

[JakeFlynn]

Use
<cfsavecontent>
tags