August 29, 2008 10:06pm pdt

1. SidFishes 67,128
2. gdemaria 52,790
3. Zvonko 50,140
4. _agx_ 36,592
5. Plucka 22,798
6. zadoc 16,280
7. dgrafx 9,500
8. msfletch 9,420
9. hielo 9,136
10. erikTsomik 8,300
11. Mr_Nil 7,000
12. SBennett 6,000
13. Yamagami 5,500
14. pigmentarts 5,000
15. b0lsc0tt 4,832
16. Jester_48 4,200
17. rob_loren... 4,100
18. angelIII 4,000
18. digicidal 4,000
20. meverest 3,500
20. adobe116 3,500
20. dwkd 3,500
23. Lolly-Ink 2,600
24. pmascari 2,504
25. Kerrdo 2,500
25. dbanttari 2,500
25. darkstar3d 2,500

1. mrichmon 217,323
2. SidFishes 162,147
3. pinaldave 152,619
4. _agx_ 136,427
5. gdemaria 135,019
6. dgrafx 99,022
7. trailblazzy... 95,698
8. anandkp 95,332
9. Plucka 83,409
10. Jester_48 75,737
11. mmc98dl1 70,536
12. Tacobell777 64,577
13. Zvonko 60,290
14. usachrisk... 59,028
15. SBennett 53,630
16. mkishline 43,784
17. hart 41,025
18. jyokum 38,360
19. shooksm 38,199
20. danrosent... 37,345
21. Mause 33,084
22. RCorfman 32,184
23. cheekycj 31,211
24. entrance... 29,240
25. Dain_An... 27,490

02.22.2008 at 03:49PM PST, ID: 23186287 | Points: 500

	[x] Attachment Details

dynamic XML

Asked by CosmicKoder in ColdFusion Studio, Extensible Markup Language (XML)

Tags: coldfusion XML

I have created a dynamic XML coldfusion file. It works great but it doesnt do everything i need it to. Currently the code i am using looks at one directory and generates a XML file based off of the contents of that directory. What i need it to do is look at multiple directories and generate a XML file. Below is the code noted of what it is doing and or i want it to do. The queraadcolumn and the query of queries is so it sorts the files properly when it generates the XML. In the XML it has a <gallery> tag that holds the albums. Right now i have only one <album>, hence looking at the contents of one directory. What i want the XML to do is look at multiple directories hence adding another <album>. Below is showing the ending XML structure i want created. The structure is based off of two directories inside of the same directory. Each directory is holding 5 JPEG's currently but i may have 1000 files in each directory.

Directory structure is : Photos/west/set1/large or Photos/east/set1/large

Thank You!

CosmicKoderStart Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:

           
           
             code i am using to look at a single directory and generate XML based off of the contents of that directory:
 
<cfdirectory action="LIST" directory="#GetDirectoryFromPath(GetBaseTemplatePath())#/photos/jayda/set1/large/" name="getPhotos" filter="*.jpg" sort="name">
<cfset queryaddcolumn(getPhotos,"mysort",ArrayNew(1))>
<cfloop query="getPhotos">
<cfset num = ListGetAt(name,1,".")>
<cfset querysetcell(getPhotos,"mysort",num,currentrow)>
</cfloop>
<cfquery name="dirlist_sorted" dbtype="query">
select *
from getPhotos
order by mysort
</cfquery>
<?xml version="1.0" encoding="UTF-8"?>
	<gallery>
		<album title="west Stage" lgPath="photos/west/set1/large/" tnPath="photos/west/set1/thumbs/">
	<cfloop query="dirlist_sorted"><img src="<cfoutput>#dirlist_sorted.Name#</cfoutput>"/>
	</cfloop>
		</album>
	</gallery>
 
 
How the ending XML should look when it is looking at multiple directories:
 
<?xml version="1.0" encoding="UTF-8"?>
	<gallery>
		<album title="West Stage" description="West Stage Set 1" lgPath="photos/West/set1/large/" tnPath="photos/West/set1/thumbs/">
	<img src="1.jpg"/>
	<img src="2.jpg"/>
	<img src="3.jpg"/>
	<img src="4.jpg"/>
	<img src="5.jpg"/>
		</album>
		<album title="East Stage" description="East Stage Set 2" lgPath="photos/East/set1/large/" tnPath="photos/East/set1/thumbs/">
	<img src="1.jpg"/>
	<img src="2.jpg"/>
	<img src="3.jpg"/>
	<img src="4.jpg"/>
	<img src="5.jpg"/>
		</album>
	</gallery>

           
         

Keywords: dynamic XML

	Title
1	Coldfusion photo album?
2	Flash photo album
3	get files and name
4	PHP + XML
5	I want datafeed of photos in xml
6	Hyperlink in XML file

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628