This is some code that communicates what I want to do. I want to pass
in a number that is the key that will match up with what's in the SQL
code.
Basically, I want to have different sets of criteria that are brought
into play depending on the var coming in.
select *
from ext_tracking
where category not in CASE #form.cat#
WHEN 1 THEN (70,80)
WHEN 2 THEN (80,100,110,120)
WHEN 3 THEN (70,80,100,110,120)
WHEN 4 THEN (70,100,110,120)
END
I don't care if a IF THEN or a CASE statement is used.
And yes, I know that I could do it with more CFML involvement, but I'd
rather not do that. This is just representative code that illustrates
the one piece I need to make the whole thing work.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2910
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
