Active Slideshow Pro Support Product Page

QUESTIONS

This topic was archived

Unable to load/parse XML. File: PhotoBoard_xml.asp

Don Anderson

Asked 08 Mar 2006 06:03:27

has this question

I also have this question

08 Mar 2006 06:03:27 Don Anderson posted:

George,

I recently purchased your Active Slideshow Pro extension for dreamweaver 8

I'm trying to create my first slide show using your tutorial and forum.
I have run into the following error:

Unable to load/parse XML. File: PhotoBoard_xml.asp?

Can you take a look at my code?
Is it a code issue or a server configuration issue?

Any Help would be greatly appreciated.

Thanks
Don

the web page is located at the following url:
www.midwesticeclimbers.com/icepit/onlinesite/groupinfo/photoboard/PhotoBoardListing2.asp

The photos in the slide show should be the same as the ones on this page:
www.midwesticeclimbers.com/icepit/onlinesite/groupinfo/photoboard/PhotoBoardListing.asp

The image file name and location is being genererated on the fly
folder / image name

following code of the pages:

PhotoBoardListing2.asp

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>

<%
var TripPhotos__MMColParam = "True";
if (String(Request("MM_EmptyValue"

) != "undefined" &&
String(Request("MM_EmptyValue"

) != ""

{
TripPhotos__MMColParam = String(Request("MM_EmptyValue"

);
}
%>
<%
var TripPhotos = Server.CreateObject("ADODB.Recordset"

;
TripPhotos.ActiveConnection = MM_loonadata_STRING;
TripPhotos.Source = "SELECT * FROM TripPhotos WHERE TripphotoBoard = "+ TripPhotos__MMColParam.replace(/'/g, "''"

+ "";
TripPhotos.CursorType = 0;
TripPhotos.CursorLocation = 2;
TripPhotos.LockType = 1;
TripPhotos.Open();
var TripPhotos_numRows = 0;
%>
<%
var HLooper1__numRows = 20;
var HLooper1__index = 0;
TripPhotos_numRows += HLooper1__numRows;
%>

<html>
<head>
<title>Welcome Loon-A-Ticks Lets Have an Outdoor Adventure</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000" background="../../../images/background.jpg" link="#0000FF" vlink="#0099FF" alink="#00FFFF">
<div align="center">
<table width="99%" border="1" cellspacing="0" cellpadding="0" height="100%">
<tr>
<td valign="top"> <div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0" name="tbmaindata">
<tr>
<td valign="top"> <div align="center">

<table width="100%" border="0">
<tr>
<td width="33%"> </td>
<td><h2 align="center">PHOTO BOARD</h2></td>
<td width="33%" align="default"> </td>
<td> </td>
</tr>
</table>

<div align="center">
<p>
<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0" width="450" height="300" id="PhotoBoard" align="middle">
<param name="FlashVars" value="xmlFile=PhotoBoard_xml.asp&preloaderBackColor=0x0099FF&preloaderBorderColor=0xCCCCCC" />
<param name="movie" value="slideshowpro.swf" />
<param name="quality" value="best" />
<param name="scale" value="noscale" />
<param name="wmode" value="window" />
<param name="bgcolor" value="#FFFFFF" />
<embed src="slideshowpro.swf" id="PhotoBoard" wmode="window" quality="best" flashvars="xmlFile=PhotoBoard_xml.asp&preloaderBackColor=0x0099FF&preloaderBorderColor=0xCCCCCC" scale="noscale" bgcolor="#FFFFFF" type="application/x-shockwave-flash" width="450" height="300" pluginspage="www.macromedia.com/go/getflashplayer" />
</object>
</p>
</div>
</div></td>
</tr>
</table>
</div></td>
</tr>
</table>
</div>
</body>
</html>

PhotoBoard_xml.asp

<%@LANGUAGE="VBSCRIPT"%>

<%
Dim PhotoBoardSlides__MMColParam
PhotoBoardSlides__MMColParam = "True"
If (Request("MM_EmptyValue"

<> ""

Then
PhotoBoardSlides__MMColParam = Request("MM_EmptyValue"

End If
%>
<%
Dim PhotoBoardSlides
Dim PhotoBoardSlides_numRows

Set PhotoBoardSlides = Server.CreateObject("ADODB.Recordset"

PhotoBoardSlides.ActiveConnection = MM_Mapquest_STRING
PhotoBoardSlides.Source = "SELECT * FROM TripPhotos WHERE TripphotoBoard = " + Replace(PhotoBoardSlides__MMColParam, "'", "''"

+ ""
PhotoBoardSlides.CursorType = 0
PhotoBoardSlides.CursorLocation = 2
PhotoBoardSlides.LockType = 1
PhotoBoardSlides.Open()

PhotoBoardSlides_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
PhotoBoardSlides_numRows = PhotoBoardSlides_numRows + Repeat1__numRows
%>
<slideshow loop="true" stream="true">
<%
While ((Repeat1__numRows <> 0) AND (NOT PhotoBoardSlides.EOF))
%>
<slide url="../../tripdetailsphotos/Photos/<%=(PhotoBoardSlides.Fields.Item("TripphotoEventID"

.Value)%>/<%=(PhotoBoardSlides.Fields.Item("Tripphotofilename"

.Value)%>" duration="3" fill="squeeze" background="0x000000">
<transition effect="fade" position="0" easing="Linear" duration="2" />
<kenburns panstart="9" panend="9" zoomstart="1.3" zoomend="1.3" />
</slide>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
PhotoBoardSlides.MoveNext()
Wend
%>
</slideshow>
<%
PhotoBoardSlides.Close()
Set PhotoBoardSlides = Nothing
%>

Replies

George Petrov

Replied 09 Mar 2006 01:23:15

09 Mar 2006 01:23:15 George Petrov replied:

you are getting an asp error as you have error in your code:

PhotoBoard_xml.asp

<%@LANGUAGE="VBSCRIPT"%>


the @@urlformat@@ should be just file=

george

--------------------------------------------------
George Petrov - Founder of the Dynamic Zones
DMXzone.com, FWzone.net, FLzone.net, CFzone.net,
DNzone.com, FlashFiles.nl
--------------------------------------------------

Don Anderson

Replied 09 Mar 2006 04:20:49

09 Mar 2006 04:20:49 Don Anderson replied:

George,

You were correct.
I should have looked closer.
I did not notice the file include call out at the top.

I changed it to file= like you pointed out and it now works.

Thanks Again and your extension rocks.

Don

Active Slideshow Pro Support Product Page

QUESTIONS

Unable to load/parse XML. File: PhotoBoard_xml.asp

Replies

Reply to this topic