Jump to content

Archived

This topic is now archived and is closed to further replies.

Whaih

retrieving the position of the row inserted.

Recommended Posts

I have a problem:

I have inserted a row into the database. And now i have them organise in asc order to my preference.
Now i would like to retrieve the position of that row that i inserted a while ago.

E.g. There are 100 records, the row that i inserted is in the no.69 position after i order them in asc order.
How am i able to code it to know that the row is in that position?

Note: using autonumber (id) is out of the question because i have asc them in a way that whenever there is a new record insert, the position will change.

Share this post


Link to post
Share on other sites
Why can't you let the database do its stuff and just store the information. Do the sorting via any query to retrieve the data.

It seems a very unuseful situation to have to sort the database all the time when as far as it is concerned it cares not a jot where things are!!!

Share this post


Link to post
Share on other sites
[!--quoteo(post=349789:date=Feb 27 2006, 05:59 PM:name=ToonMariner)--][div class=\'quotetop\']QUOTE(ToonMariner @ Feb 27 2006, 05:59 PM) [snapback]349789[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Why can't you let the database do its stuff and just store the information. Do the sorting via any query to retrieve the data.

It seems a very unuseful situation to have to sort the database all the time when as far as it is concerned it cares not a jot where things are!!!
[/quote]


Hmmm, i'm doing an application to know the position of the runner base on the timing inserted. That's y i need to know where is the row inserted

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.