The following looks like a nice way to do it:
http://cfdj.sys-con.com/read/41898.htm
I guess I mayhave to lose the cfqueryparams, if I go down this path.
>>> [EMAIL PROTECTED] 07/18/05 10:17 am >>>
Dude. That's huge!
Personally, I don't do my processing in the query itself. I create
variables along the way and then join them all up in my query, like
so:
<cfquery name="qryGetPresentationData">
SELECT #variables.sqlSelectFieldNames#
FROM
#variables.PreFROMLeftParentheses##qryGetPresentationFieldsToDisplay.ObjectTableName##variables.FROMLeftJoins#
</cfquery>
Not nearly as complex as yours, but it can scale. Probably not the
most efficient. Probably should just ignore the idea.
Chad
who thinks home builders forget about winter when they build houses in Australia
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
