is bottom a keyword that i can use? i guess so, or else you wouldnt have suggested it right :)
tw -----Original Message----- From: Brian Scandale [mailto:Brrrian@;Excite.com] Sent: Friday, October 25, 2002 11:02 PM To: CF-Talk Subject: Re: SQL OT: selecting bottom most 10 records Why not use SELECT BOTTOM 10 .... Order by ID ASC ??? At 07:08 PM 10/25/02, you wrote: >brain fartage....never had to make this work... >i only want to select the bottom most ten records >based on a primary key ID field..... > ><cfquery name="getWriter" datasource="survivorsmiles"> > select TOP 10 (ID), firstname, lastname, email > from reg > where id = #getStories.writer_Id# > order by ID > asc ></cfquery> > >aint cuttin it? why...cause it doesnt make any sense....just trying to >give you an idea of the field i need and hoping that somehow i can do >this :) > >please help. > >thanks > >...tony > >tony weeg >[EMAIL PROTECTED] >www.revolutionwebdesign.com >rEvOlUtIoN wEb DeSiGn >410.334.6331 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
