What you see when you look at a database table in some kind management tool doesn't necessarily equate to what you'll get if you do a select * from table.
The only way to reliably retrieve a row from a table is using a unique identifier.
Given that you're trying to build a next/previous, the best way to handle this is to cache the query in some way. If this is something that will be used regularly by multiple users of the site, simply use the cachedwithin attribute of cfquery, then pass the row number using the next/previous buttons on your page and access the query as queryname.columnname[thisrownumber].
If the query is the result of the search, then you could chuck the query into a session variable. You need to check to see if the session variable exists before you re-do the query, but if it exists you can access the record set direct from the session variable, as described above. (session.queryname.columnname[rownumber])
Hope this gives you something to work from
Regards
Stephen
Lovelock, Richard J wrote:
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]
