Hi there,
I have a database with two fields, one for title and second one for image. The purpose is to display the images inserted into the database on a gallery in a dynamic page.
I want the pictures to appear in a certain order and when I insert them onto the database in a desired order, they automatically sort into a what seems to be a random order. the images are then displayed mixed on a gallery and not in the order I need it to be displayed.
I have tried renaming the pictures in numbers so " 1, 2, 3…" but I can’t seem to get it to work.
I have not put any sorting on the database or on the manage database section in a dynamic page, so I am not sure as to why it does that. please advise.
If you are using a dataset, the dataset has a default sorting based on the created dates of the items. If you want to control the order in the gallery you can sort the dataset using different criteria. If you rename the pictures you can use the title field, but I would recommend creating another field for this purpose.
Reread your question, and it is prob. the last. What Sam tried to explain is that, if you use no sorting criterium, everything from a dataset is sorted by default on creation date (of the row, not the pic). If you want another sorting order, AND THERE IS NO LOGICAL RELATION BETWEEN THE PICS, then you must add a third field, like ‘SortID’ into your collection. You (or somebody else, sets the order of the pics by providing 1,2,3,4,5 etc per group of pics), and, when dislaying, you sort on that field. Hope that is clear.
The pictures are in one row. I have managed to fix the problem. I have had to add them in reverse order in sandbox and only copy the new entries to the live by selecting them.
Thanks for the response guys