jeeze... trying is WAY faster than asking ;-)
At 08:04 PM 10/25/02, you wrote: >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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
