ah, thank you very much >Something like this: > ><cfsaveContent var="theSQL"> >SELECT ... >FROM ... >WHERE ... >GROUP BY ... >ORDER BY ... ></cfsaveContent> > ><cfquery ...> >#theSQL# ></cfquery> > >Add <cfoutput>s as required. > > >Confidentiality Notice: This message including any >attachments is for the sole use of the intended >recipient(s) and may contain confidential and privileged >information. Any unauthorized review, use, disclosure or >distribution is prohibited. If you are not the >intended recipient, please contact the sender and >delete any copies of this message.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
