TOP ??
_______________________________________________________
* Regards,
Richard Lovelock
Westminster City Council - Web Support
Cap Gemini Ernst & Young
Southbank
95 Wandsworth Road
London
SW8 2HG
( 0870 906 7482
_______________________________________________________
-----Original Message-----
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 10:10
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Rownumber in query
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]
