how about that - adding an additional column to the order by clause fixed it!
thanks heaps adrian. >Have a read of this: > >http://articles.techrepublic.com.com/5100-22-5035113.html > >Might explain things. > >Adrian > >-----Original Message----- >From: Mike Little >Sent: 11 July 2007 00:19 >To: CF-Talk >Subject: Re: Selecting top row in access db > > >ok, it appears to be my order by clause. having simply ORDER BY article_id >DESC works? if anyone can expand on this for me it would be appreciated as i >really would like to order as i have in the query that does not work... > >query. >> >>Regards >>Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283435 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
