Hey all, got a non-porn-related question. Using MySQL 4.1 --
I have a query that is basically like this, it works great: SELECT CASE a THEN b CASE c THEN d etc... END as myalias But, I'd like to do more in the THEN clauses - set more than one alias, like this: SELECT CASE a THEN b as b1, c as c2 CASE d THEN e as e1, f as f2 END This fails because you can only return a string or integer in the THEN clauses. It seems silly to have a big 'ol CASE statement, with the same logic, for each alias that I want to set. Is this something that could be accomplished in a stored proc? I've not used them before, but I'm willing to learn them if it will accomplish what I'm after. Or is there a nifty way to do what I want using plain SQL? -- Josh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273195 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
