> Morning all.. Morning!
> 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 Rownumber is actually not part of the SQL, but is a part of the object/recordset/whatever returned from the database. In other words, if you have 20 rows returned and you want row 9, then to retrieve the full record of "row 9" the SQL needs a unique identifier within the database, and not the rownumber (because, that can be a different record from the one you actually want when you return to the database to retrieve it!). So iow, what you are after is: 1) in CF, retrieve the unique identifier (the key) for the row (row number 9 or whatever) 2) do a SQL statement to retrieve the record (or records) for that unique identifier... HTH Paul -- ** 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]
