You would need to specify somehting from that row in a where clause Select * from table Where somecolumn = 'somevalue'
If you do not know any field values, you can just select everything or at least the top 10 if u want record 9 and then just output the row you want. E.g <cfoutput>#queryname.column[row]#</cfoutput> Russ Michaels Macromedia/Allaire Certified ColdFusion Developer CFMX Hosting Phone: 0845 456 3487 Tech Support: 0906 9607800 FAX: 0709 2212 636 WEB: cfmxhosting.co.uk >Please use the support helpdesk on our web site to submit support tickets.< Join our ColdFusion Developer discussion lists. Send an e-mail to [EMAIL PROTECTED] > -----Original Message----- > From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] > Sent: 06 October 2003 10:02 > To: 'cflist' > Subject: [ cf-dev ] Rownumber in query > > > Morning all.. > > there is probably a straightforward way to do this but i > can't think of it... > > if i know the rownumber of a table that i want to retrieve > how can i tell CF/ Access to bring me back that specific row > in the table (the table doesn't have a column called row > number or anything) > > e.g. > SELECT * > FROM xyz > WHERE rownumber = 9 > > is there something I can replace 'rownumber' with to do this > or some other way? > > (this is being used for prev/next page nav and i want to add > one to the row number each time next is pressed to retrieve > next row etc) > > _______________________________________________________<?xml:namespace > prefix = o ns = "urn:schemas-microsoft-com:office:office" /> > > * Regards, > Richard Lovelock > > Westminster City Council - Web Support > Cap Gemini Ernst & Young > Southbank > 95 Wandsworth Road > London > SW8 2HG > > ( 0870 906 7482 > > _______________________________________________________ > > > > > ************************************************************** > ****************************** > " This message contains information that may be privileged or > confidential and > is the property of the Cap Gemini Ernst & Young Group. It is > intended only for > the person to whom it is addressed. If you are not the > intended recipient, you > are not authorized to read, print, retain, copy, disseminate, > distribute, or use > this message or any part thereof. If you receive this message > in error, please > notify the sender immediately and delete all copies of this message ". > ************************************************************** > ****************************** > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
