Using Coldfusion with XML for Flash photogallery

Report · Nov 09, 2008

Hello community. I have created a site for my son's kindergarten for free because I wanted to say thanks, since my son was very happy.
The site has been created using coldfusion because I gave them some control on news, new children, waiting list, etc.
They just asked me they want to be able to modify all the content of the site, so I started working on a CMS for it.
There are two section on the site, video gallery and photo gallery that are flash - XML based galleries.
I know that if I explain to them how to modify the XML files in order to change photos and videos, they'll screw the gallery.
Is there any way I can access the content of my XML file from coldfusion and allow modification, like adding new photos to the existing ones, or modifying the caption on the existing ones?

So basically I need to them to be able to click on "Modify photo gallery", then see all the childs (photos) and be able to modify/add.

Thank you so much for any info or help.

Report · Nov 09, 2008

quote:

Originally posted by: DaniFusionWeb
Hello community. I have created a site for my son's kindergarten for free because I wanted to say thanks, since my son was very happy.
The site has been created using coldfusion because I gave them some control on news, new children, waiting list, etc.
They just asked me they want to be able to modify all the content of the site, so I started working on a CMS for it.
There are two section on the site, video gallery and photo gallery that are flash - XML based galleries.
I know that if I explain to them how to modify the XML files in order to change photos and videos, they'll screw the gallery.
Is there any way I can access the content of my XML file from coldfusion and allow modification, like adding new photos to the existing ones, or modifying the caption on the existing ones?

So basically I need to them to be able to click on "Modify photo gallery", then see all the childs (photos) and be able to modify/add.

Thank you so much for any info or help.

If you are using ColdFusion 7/8 this should be quite easy. You'd basically:

1) Read the XML file into ColdFusion memory
2) Loop through the nodes you need etc outputting them to a page or dynamically built form fields
3) Allow the user to edit these fields then on submit have ColdFusion tale the variable holding the form data and write it to an XML file again via a loop, overwriting the previous file.

Clearly you'll need to be careful on validating the input but it should be pretty straightforward.

I didn't have time to write any code but look at the following functions and tags to find out more:
<cffile />
<cfxml />

Here's some more info:
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_u-z_4.html

Cheers,
Mikey.

Report · Nov 11, 2008

Mikey, thanks so much for your answer!!.
What I thought, I have to implement it, is to have a table in a database where they can add/modify images or videos. Once they do that, then CF converts the query results into an XML file. So basically the XML file is created once the table as been created or modified.
Again these are my thoughts, but I havn't tried them yet.

I'll try to get more info about your idea and try to implement it too.

Again, thanks a lot!!