> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Bobby, > > This doesn't work for me because the values in the database > are in a numeric column and stored as 1 or 0. I need the > query to return 'yes' or 'no'. The query results are used > for a CFINDEX, so the only option I can think of at this > point is to build a NEW query and transform those values as I > loop through the original query recordset. This will add > alot of overhead to the process though. > > I can't do a PL/SQL function either, so that's not an option. > > Anyone else have any other ideas?
I am not familiar with Oracle but what about a CASE statement? When field is 1 then 'yes', etc... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217007 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
