Database Sorting Structure
Posted: Fri Jul 11, 2003 11:28 am
Hello,
I have a question that i need some advice on
i have a database which lists a catalog of products. I want to be able to display these products sorting it based on an order of priority.
now i thought of 2 options
1 altering the code (primary key) - i wanted to do this option into a squencial format but i did not want to tamper with it as the data is related its real life inforamtion.
2 creating a sort column in which would create a sequence sort number but what i would run into problems when i have a new product entered and it needs to be more priority than those already there.
[quote]
What methods of sorting do you guys use in a situation like this?
[/quote]
[quote]
what options do i have or what should be my most effecient option?
[/quote]
Kendall
I have a question that i need some advice on
i have a database which lists a catalog of products. I want to be able to display these products sorting it based on an order of priority.
now i thought of 2 options
1 altering the code (primary key) - i wanted to do this option into a squencial format but i did not want to tamper with it as the data is related its real life inforamtion.
2 creating a sort column in which would create a sequence sort number but what i would run into problems when i have a new product entered and it needs to be more priority than those already there.
[quote]
What methods of sorting do you guys use in a situation like this?
[/quote]
[quote]
what options do i have or what should be my most effecient option?
[/quote]
Kendall