Yeah, I am thinking that I need to redo the table. On the query I am not doing any groupings as there are way too many fields and I am joining another SQL Server to get the street names and route names/ID's. All I am doing on the query is an order by Route_Name, and like I said, when I run the query in Studio Manager, the data comes out right. The dupes were already there and have been deleted. User entered the same information twice. Regarding the time issues, that is something else I need to work out.
Thanks, Bruce -----Original Message----- From: Dave [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 5:41 PM To: CF-Talk Subject: RE: data not outputting correctly Don't know if your doing any grouping in the query, but you are in the output. Is it possible that this grouping is somehow reordering the query? I would look at the query again only because I am seeing data duplication on route 11 and time values out of order on several routes (i.e. 8, 18 and 13). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
