As I understand it, you're asking about how to store it - irrelevant of how you display it.

To me, this is dependent on a couple of factors:

1) Is this strictly an ordering thing, or a priority thing? In other words, will there be gaps (like, record A has a 10 priority, record B has 20), or is it very ordered, like a linked list (hint) ?

2)  How often does it change?

I've often been faced with the challenge of being able to insert something into a custom ordered set without having to change ALL of the objects in the set. This is why something like an integer from 1 to X doesn't really work - it might affect too many objects. If it's a situation like that, I prefer to have either links in the EO's to each other, or an external EO that manages the linked list for me. That way, insertions are a no-brainer - we just move the relationships around.

In general, this is the approach I favor, since you never have to do a problem resolution phase (like 2 records have the same double or int, etc).

Ken

On Apr 27, 2006, at 9:34 AM, Amedeo Mantica wrote:

Hello friends!

does anyone have an idea how to implement a custom row ordering in a database?

My customers want to custom order row in database

i can create an ordering column with a double type (number) so i can always move a row between two others...

Actually I don't know how to graphically impement this (user interface)

do you have ideas? or other methods?

Thanks
Amedeo
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/lists% 40anderhome.com

This email sent to [EMAIL PROTECTED]

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to archive@mail-archive.com

Reply via email to