ORDER BY ascList that still gives me ascList 132 135 135,132
On Tue, May 13, 2008 at 12:37 PM, Robert Harrison < [EMAIL PROTECTED]> wrote: > Order by ascList... that should get DISTINCT to work. > > > <cfquery name="getAccessory" datasource="listit"> > SELECT DISTINCT ascList > FROM dbo.list > WHERE (specs_partnum IN (#columns#)) AND (ascList IS NOT NULL) > ORDER BY ascList > </cfquery> > > Robert B. Harrison > Director of Interactive services > Austin & Williams > 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 > T : 631.231.6600 Ext. 119 > F : 631.434.7022 > www.austin-williams.com > > Great advertising can't be either/or... It must be &. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:305182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4