For our customer we want to create a possibility where editors can upload/select photos via a component and where the information about these photos can be sent to a secondary system as a xml file.
So we have created a table in FirstSpirit and called it photo_serie. Within this table we have added a column named photos which could contain multiple photos per row.
This can be achieved because we have created a form upon this table with a CMS_INPUT_CONTENTAREALIST (named st_photo_serie) which we have mapped (in the mapping) to the specified column (photos). The CMS_INPUT_CONTENTAREALIST is based upon a template named pictures which again has several components (CMS_INPUT_PICTURE, CMS_INPUT_TEXT for additional info, width, height, acknowledgement info, etc.)
We have created a datasource with the same name (photo_serie).
After this we created a datasource in which we defined a CMS_HEADER in the jsp (HTML) tab with a contentSelect function (and a query referring to the given table):
<CMS_FUNCTION name="contentSelect" resultname="photo_serie_rs">
<CMS_PARAM name="schema" value="dbschema" />
Below the CMS_HEADER we are now trying to define our XML. However when trying to loop through the items no result is being displayed:
$CMS_IF(!single_photo_serie.photos.isEmpty)$ //this still works
//We have tried several options to get information out of this 'object', but up to now with no luck
//What should be set here to get the information of one specific photo in the set as defined in the pictures template
//together with the UID of the specific photo in the mediastore AND the URL of this media (in the same way the navigation fuction
//builds these URL's).
First of all I would like to know if the whole setup is the right way to go (if not, please advise how this should be set up) and second if it is the right way to go, then I would to see an example which runs through the items stored in each specific column with the CONTENTAREALIST and get information of the several items (photos) in the set.