Hello all.
Often times in our database we have web pages built off of the order in
which data is retrieved from the database. For the most part this data is
retreived in the same order in which it was put in.
For Example we put in the following info
song1, title2
song2, title2
song3, title3
Each row being a new record. Now the oid given to these is obviously in the
same order in which they are written. But what we see hapenning is that the
order in which these are retrieved is changing. For example it would come
out:
song1, title1
song3, title3
song2, title2
If you were to order it by oid it would come out the way it was put in.
My question is, what would cause the data to come out differently all of a
sudden, as in it comes out the right way one day, and then off the next, and
the only thing that has been done, is that more data has been added to the
table. Could that cause it to shift like that. Normall we select this by
no order. Is it safe to select it by the oid....as in the oid will NOT
change, even though the order in the database is shifting?
Thanks for any insight.
Darren
