The below is querying a SQL Server VIEW.
I'm trying to return distinct atty_id, but I'm still getting some
records returned multiple times.
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:305260
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
