I have a list of organizations, their email, address, phone, contact person etc...
The displayed table is as follows: Organization - Address - Phone - Contact Person <a href="mailto:#email#";>Organization Name</a> - #address# - #phone# - #contactPerson# Now, things became a little more complicated. Some organizations have more than one contact person and we want to have their names link to their personal email. Here's the issue, some people have email accounts, others don't -- incredible isn't it that some people still don't have email? :-} Anyway what I would like is for those that have email accounts to have their names linked and for those that don't have email accounts to remain unlinked. There are hundreds of names so I don't want to do a <cfif> on each .... err I mean <cfswitch>. Two querries could be done, one with names with email and one without but would it be more efficient than 100s of <cfswitch>? Not to mention that I'm not too sure on how I would be able to display the querried solution. Each column name is linked allowing users to order (ASC & DESC) by that column. thx. Gilbert Midonnet ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
