While on the subject of report builder, how can you do conditional queries?
For example on a cfm template I could use the following...
<cfquery>
SELECT *
FROM aTable
<cfif isDefined('url.someVar')>
WHERE someID = #url.somevar#
</cfif>
ORDER BY someID
</cfquery>
However this is not possible in report builder so I currently use two
separate cfr files. Is there an alternative to this?
--
Jay
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272000
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
