Forum OpenACS Development: Re: Ordering photos in the photo album

Collapse
Posted by Jeff Davis on
you should not need to add any metadata for sorting photos since you should be manipulating the cr_child_rels order_n field for sort order of photos withing a folder.
select * from cr_child_rels where relation_tag = 'pa_album-pa_photo';
to see the rows that are there.

I doubt sorting in the db is really that bad if there are statistics on the db and the query optimizer works.

Collapse
Posted by Bart Teeuwisse on
I've modified my copy of photo album to use the order_n field to sort photos. The order_n values can be modfied on the album edit page.

I recommend coordinating your changes with Rocael whom I've sent my changes and is committing many of them along with his own work to the OpenACS repository.

/Bart