Hi,
below is a some asp code that creates some XML and stores it into a variable called myXMLData.
<%@LANGUAGE = VBScript%>
<%
DIM myXMLData
myXMLData = ""
myXMLData = myXMLData &"<?xml version="&CHR(034)&"1.0"&CHR(034)&" encoding="&CHR(034)&"UTF-8"&CHR(034)&"?>"
myXMLData = myXMLData &"<gallery>"
myXMLData = myXMLData &"<album title="&CHR(034)&"General Images"&CHR(034)&" description="&CHR(034)&"Images from the Gen Database"&CHR(034)&" lgPath="&CHR(034)&"dib/gen_dib_data/images/"&CHR(034)&" tnPath="&CHR(034)&"dib/gen_dib_data/thumbs/"&CHR(034)&" tn="&CHR(034)&"dib/gen_dib_data/thumbs/ab_0001.jpg"&CHR(034)&">"
%> <%
Dim oConn2, oRS2, strSQL2
Set oConn2 = Server.CreateObject("ADODB.Connection")
Set oRS2 = Server.CreateObject("ADODB.Recordset")
oConn2.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("dib/gen_dib_data/gen_dib_data.mdb")
strSQL2="SELECT Photo.Filename, Photo.PDesc, Photo.PhotoID, Photo.PhotogID, Photographer.Fullname FROM Photo INNER JOIN Photographer ON Photo.PhotogID = Photographer.photogID WHERE (((Photo.PhotogID)=12)) ORDER BY Photo.PhotoID;"
oRS2.Open strSQL2, oConn2, 2, 3
Do While Not oRS2.EOF
%> <%
myXMLData = myXMLData &"<img src="&CHR(034)&oRS2("Filename")&CHR(034)&" caption="&CHR(034)& "GE-" & oRS2("PhotoID")& " - "& oRS2("PDesc") & " - by "& oRS2("Fullname")&CHR(034)&" />"
%> <%
oRS2.MoveNext
Loop
oRS2.Close
Set oRS2 = Nothing
oConn2.Close
Set oConn2 = Nothing
%><%
myXMLData = myXMLData &"</album>"
myXMLData = myXMLData &"</gallery>"
%>
and this is the output if I do a response.write myXMLData
<?xml version="1.0" encoding="UTF-8"?>
<gallery>
<album title="General Images" description="Images from the Gen Database" lgPath="dib/gen_dib_data/images/" tnPath="dib/gen_dib_data/thumbs/" tn="dib/gen_dib_data/thumbs/ab_0001.jpg">
<img src="f1_0016.jpg" caption="GE-243 - Renault display at Goodwood racetrack - by Ian Harris" />
<img src="f1_0029.jpg" caption="GE-244 - Sauber Pit lane - by Ian Harris" />
<img src="f1_0037.jpg" caption="GE-245 - Mclaren - Kimi Raikkonen - by Ian Harris" />
<img src="f1_0038.jpg" caption="GE-246 - Renault Transportation Lorries - by Ian Harris" />
<img src="f1_0040.jpg" caption="GE-247 - Goggles - by Ian Harris" />
<img src="f1_0041.jpg" caption="GE-248 - Renault- Fernando Alonso - by Ian Harris" />
<img src="f1_0147.jpg" caption="GE-249 - Jaguar - Test Driver - by Ian Harris" />
<img src="f1_0148.jpg" caption="GE-250 - Jaguar - Test Driver - by Ian Harris" />
<img src="f1_0162.jpg" caption="GE-251 - McLaren - David Coulthard - by Ian Harris" />
<img src="f1_0163.jpg" caption="GE-313 - McLaren - Trackside - Kimi Raikkonen - by Ian Harris" />
<img src="f1_0164.jpg" caption="GE-314 - Jaguar - by Ian Harris" />
</album>
</gallery>
I have just purchased a slideshow component for Flash called Slideshowpro which is able to import xml via the flashvars method by declaring a file name.
However, I want to use a variable to import because it will enable me to create all sorts of queries and output as xml and store it in a var each time.
The flash component sits in Layer 1 instance name ssp and no action script present.
Layer 2 has one line of code ssp.xmlFilePath=xmlfile;
<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="[http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0](http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0)" width="465" height="490" id="slideshow" align="middle">
<param name="FlashVars" value="xmlfile=myXMLData" />
<param name="allowScriptAccess" value="sameDomain" />
<param name="movie" value="slideshow.swf" />
<param name="quality" value="Best" />
<param name="bgcolor" value="#ffffff" />
<param name="menu" value="false">
<param name="wmode" value="transparent">
<embed src="slideshow.swf" FlashVars="xmlfile=myXMLData" quality="Best" bgcolor="#ffffff" width="465" height="490" name="slideshow" align="middle" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="[http://www.macromedia.com/go/getflashplayer](http://www.macromedia.com/go/getflashplayer)" menu="false" wmode="transparent" />
</object>
my question is am I able to pass a variable that holds the xml data into this?
I can’t get it to work at all. If copy and paste the contents of the variable into an xml file and point the flash at that it loads the images fine. Is there a way to add action script to exept the xml as variable and then pass it on to ssp that way?
many thanks in advance,
Rob.