That reminds me of a function I did when CF 5 came out. I was so enamoured with UDFs that I created this nifty function to add single quotes around a list of values for use inside of a query "IN" statement... I showed it off to a fellow CF'er and he said... "why not just use listqualify( )? ... doh'! Then I learned of cfqueryparam and even that fell by the wayside :)
-----Original Message----- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 30, 2006 8:16 PM To: CF-Talk Subject: RE: YesNoFormat() is cool! Will, I believe that one was added back in CF2, although might have been earlier. ;-) --- Ben -----Original Message----- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 30, 2006 9:02 PM To: CF-Talk Subject: YesNoFormat() is cool! Just wanted to post about this function I just found in the back of WACK... the very last function. I use a lot of bit data types in my db. Then it sucks when you need to output a "yes" or a "no" on your site. YesNoFormat() takes care of it for me. So I can say: Memmership Active: <cfoutput>#YesNoFormat(getmembers.memberisactive)#</cfoutput> That'll output a "yes" or "no". Wish I'd known about that one sooner! Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251568 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
