ya my case should be like that, but i need to pass that result to the cfgrid, along with some ohter rows
>IIF is a ColdFusion method, you can't use it in SQL like that. What you're >probably looking for is CASE: > >CASE WHEN u.userid = s.lead_mgr THEN u.first ELSE s.lead_note END AS leadMgr > >Francois Levesque >http://blog.critical-web.com/ > > >On Mon, Jul 20, 2009 at 9:31 AM, RamaDevi Dobbala <ramadobb...@gmail.com>wrote: > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
