.. We are all cf developers of varying levels of ablity - one thing about the cf community I always belived was it wasn’t so much as RTFM group as so many other lanagues are but this list gave good and explained advice on any code questions kinda like a certain level of standards -
Rather than a post saying something that makes sence to you should really post any / all advice in an easy to understand and teaching method to a user as you cannot assume there tech level - ps this aint a flame or rant ,, just a gentle reminder to all posters - we could all do a bit better in our replys to questions ( and I should run a spell checker :O ) - p -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 06 October 2003 10:24 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Rownumber in query What are you talking about... 1. It cant be done Natively. 2. You can mimic it via TOP 3. ORDER the results 4. Output the first .. Whats wrong with that? :-) -----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 06 October 2003 10:19 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Rownumber in query Neil, If you can't be arsed to write a sensible email don't please bother at all. Robertson-Ravo, Neil (RX) wrote: > It cant be done....well, not natively, you will have to a TOP and output the > first result after ordering it. > > > > -----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] -- ** 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.522 / Virus Database: 320 - Release Date: 29/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.522 / Virus Database: 320 - Release Date: 29/09/2003 -- ** 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]
