I should add to this - the RANK table has a many to one relationship with the ATTY table - an attorney may be ranked multiple times, depending on what area of law they practice ... high rank for one area of law, low for another.
> SELECT DISTINCT(atty_id), > first_name, > last_name, > COALESCE(atty_rank, 9999) as atty_rank > FROM get_attypa > WHERE isACTIVE = 'y' > ORDER BY atty_rank, last_name, first_name > > > > ATTY - (Main Table) > -------------- > atty.atty_id > atty.first_name > atty.last_name > > RANK > -------------- > rank.atty_id (tied to atty.atty_id, but marked NOT to display) > rank.atty_rank > > > > Ideas? > > Is there a way to define this in the VIEW instead of in the CFQUERY tag? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305261 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
