3D ImageFlow Gallery Support Product Page

This topic was archived

Cant get it to work dynamically, asp

Reported 21 Dec 2007 13:23:36
1
has this problem
21 Dec 2007 13:23:36 James Noon posted:
Hi

Works when using just images straight into the xml file but I'm trying to pull dynamically.

I have followed the tutorial and modified the xml file to have a .asp extension and looped the image tag part, see code below.

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include virtual="/Connections/connChameleon.asp" -->
<%
Dim rsPhotos__MMColParam
rsPhotos__MMColParam = "2"
If (Request("MM_EmptyValue" <> "" Then
rsPhotos__MMColParam = Request("MM_EmptyValue"
End If
%>
<%
Dim rsPhotos
Dim rsPhotos_cmd
Dim rsPhotos_numRows

Set rsPhotos_cmd = Server.CreateObject ("ADODB.Command"
rsPhotos_cmd.ActiveConnection = MM_connChameleon_STRING
rsPhotos_cmd.CommandText = "SELECT * FROM dbo.tblPhotoGallery WHERE CatID = ?"
rsPhotos_cmd.Prepared = true
rsPhotos_cmd.Parameters.Append rsPhotos_cmd.CreateParameter("param1", 5, 1, -1, rsPhotos__MMColParam) ' adDouble

Set rsPhotos = rsPhotos_cmd.Execute
rsPhotos_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
rsPhotos_numRows = rsPhotos_numRows + Repeat1__numRows
%>
<imageflow
autoFlip="false"
flipInterval="3"
flipSpeed="1"
angle="35"
depth="250"
spaceMain="225"
spaceBack="60"
descColor="0x717171"
descSize="12"
hasReflection="true"
reflectionStrength="30"
reflectionSize="30"
reflectionBackground=""
imgWidth="300"
imgHeight="220"
startImage="">
<title color="0x717171" size="20">Deering Gallery</title>

<%
While ((Repeat1__numRows <> 0) AND (NOT rsPhotos.EOF))
%>
<image url="images/gallery/<%=(rsPhotos.Fields.Item("PhotoURL".Value)%>" target="_blank" width="640" height="480"><![CDATA[]]></image>

<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsPhotos.MoveNext()
Wend
%>


</imageflow>
<%
rsPhotos.Close()
Set rsPhotos = Nothing
%>


When I view the source for this page, all looks good I think. I have modified the link to this file within the flash area, see below.

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
<script src="scripts/AC_RunActiveContent.js" type="text/javascript"></script>
</head>

<body>
<script type="text/javascript">
AC_FL_RunContent( 'codebase','download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','700','height','350','name','3DFlowGallery1','src','imageflowgallery/3DFlowGallery','quality','best','pluginspage','www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','wmode','transparent','flashvars','xmlFile=imageflowgallery/3DFlowGallery1_xml.asp','movie','imageflowgallery/3DFlowGallery' ); //end AC code
</script><noscript><object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="700" height="350" name="3DFlowGallery1">
<param name="movie" value="imageflowgallery/3DFlowGallery.swf" />
<param name="wmode" value="transparent" />
<param name="FlashVars" value="xmlFile=imageflowgallery/3DFlowGallery1_xml.asp" />
<param name="quality" value="best" />
<embed src="imageflowgallery/3DFlowGallery.swf" quality="best" name="3DFlowGallery1" pluginspage="www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="700" height="350" wmode="transparent" flashvars="xmlFile=imageflowgallery/3DFlowGallery1_xml.asp"></embed>
</object></noscript>
</body>
</html>

But when I try to view the page, no images display and I get the text 'undefined' for both the title and description. (I did not put a title and description for the images)

Hope you can help George, many thanks, James

Replies

Replied 21 Dec 2007 14:52:47
21 Dec 2007 14:52:47 George Petrov replied:
Hi James,

Well it looks good to me, maybe you can open the link to the asp file that generates the xml in IE to see if it says it is valid XML.

Also see what the real problem is the following might help:


1. Make sure you have Firefox (www.getfirefox.com) and also the Firebug debugger installed (www.getfirebug.com)

2. Open Firefox - make sure Firebug is enabled.

3. Open the page using 3D ImageFlow Gallery in Firefox

4. Open Firebug (either from the menu's or from the green icon in the right side of the status bar in Firefox)

5. Go to the tab "Net" to see all downloads - make sure that "All" is selected so you see all kind of files

6. Locate the call to xml file see - if it is all fine.

7. Click on it and then choose the "Response" tab, If any asp error occurred you should see it there as well

8. check if the list of files in the "Net" tab - there shouldn't be any red ones - indicating that files are missing.

Greetings,
George

--------------------------------------------------
George Petrov - Founder of the Dynamic Zones
DMXzone.com, FWzone.net, FLzone.net, CFzone.net,
DNzone.com, FlashFiles.nl
--------------------------------------------------
Replied 21 Dec 2007 19:23:31
21 Dec 2007 19:23:31 James Noon replied:
Hi George

I have uploaded to my server at

www.eaglemusicshop.com/3dgallery.asp

and the edited xml page is at

www.eaglemusicshop.com/imageflowgallery/3dflowgallery1_xml.asp

I've tried firebug but dont see any errors???

Thanks, J
Replied 21 Dec 2007 19:30:04
21 Dec 2007 19:30:04 James Noon replied:
It seems the actual source code of the asp page (the generated xml) is ok, and that because the flash file is pointing to an asp page, it doesnt ready the xml ????
Replied 01 Jan 2008 07:25:31
01 Jan 2008 07:25:31 Vitor Fernandes-Neto replied:
Hi James

This is a note to everyone that has having problem with the 3D Flow Gallery:

if you are using asp make sure you open the connection within the same page (and dont use an INCLUDE FILE AS DREAMWEAVER BY DEFAULT DOES) in the xml file please see the example below.

**************************************************************

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>

*****************************************
<%Dim MM_MYCONNECTION_STRING
MM_MYCONNECTION_STRING = "dsn=mydb;"
%>
*****************************************
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows

Set Recordset1_cmd = Server.CreateObject ("ADODB.Command"
Recordset1_cmd.ActiveConnection = MM_MYCONNECTION_STRING
Recordset1_cmd.CommandText = "SELECT * FROM fotogallery"
Recordset1_cmd.Prepared = true

Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%><imageflow
autoFlip="false"
flipInterval="3"
flipSpeed="1"
angle="35"
depth="250"
spaceMain="225"
spaceBack="60"
descColor="0x717171"
descSize="12"
hasReflection="true"
reflectionStrength="30"
reflectionSize="30"
reflectionBackground=""
imgWidth="300"
imgHeight="220"
startImage="">
<title color="0x717171" size="20"><![CDATA[A Galeria da Joana]]></title>
<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%><image url="photos/<%=(Recordset1.Fields.Item("picture".Value)%>" target="_blank" width="400" height="300" selected="true"><![CDATA[]]></image><%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
</imageflow>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>



***************************************************

Hope this helps everyone with the problem that i had

regards to you all

vitor<font color=red></font id=red> <BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> <BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Edited by - vitor123 on 01 Jan 2008 07:27:19
Replied 05 Jan 2008 14:55:31
05 Jan 2008 14:55:31 George Petrov replied:
see also www.dmxzone.com/forum/topic.asp?topic_id=40370&NewsId=13986

--------------------------------------------------
George Petrov - Founder of the Dynamic Zones
DMXzone.com, FWzone.net, FLzone.net, CFzone.net,
DNzone.com, FlashFiles.nl
--------------------------------------------------
Replied 11 Jan 2008 15:10:42
11 Jan 2008 15:10:42 Deon Kretzschmar replied:
Hi.
Had a look at all the samples on the site and tried everything. Even used Firebug to copy the generated XML (from the ASP) to a
blank XML file and set everything up to run from this file the and then it works. Somehow it does not want to read the generated XML from the ASP.

I only get the following in my browser when running from the ASP file: "undefined"
Running VISTA Business with all the required ASP setup fixes (all other ASP pages work fine)

Here is the code:
-------------------
&lt;%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%&gt;
&lt;%
Dim MM_aa_STRING
MM_aa_STRING = "dsn=aadb;"
%&gt;
&lt;%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows

Set Recordset1_cmd = Server.CreateObject ("ADODB.Command"
Recordset1_cmd.ActiveConnection = MM_aa_STRING
Recordset1_cmd.CommandText = "SELECT * FROM gal"
Recordset1_cmd.Prepared = true

Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%&gt;
&lt;%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%&gt;&lt;imageflow
autoFlip="false"
flipInterval="3"
flipSpeed="1"
angle="35"
depth="250"
spaceMain="225"
spaceBack="60"
descColor="0x717171"
descSize="12"
hasReflection="true"
reflectionStrength="30"
reflectionSize="30"
reflectionBackground=""
imgWidth="300"
imgHeight="220"
startImage=""&gt;
&lt;title color="0x717171" size="20"&gt;&lt;![CDATA[Audience Alive Gallery]]&gt;&lt;/title&gt;
&lt;%
While ((Repeat1__numRows &lt;&gt; 0) AND (NOT Recordset1.EOF))
%&gt;&lt;image url="gallery/&lt;%=(Recordset1.Fields.Item("gimage".Value)%&gt;" target="_blank" link="gallery/&lt;%=(Recordset1.Fields.Item("gimage".Value)%&gt;" width="400" height="300" selected="true"&gt;&lt;![CDATA[&lt;%=(Recordset1.Fields.Item("gdesc".Value)%&gt;]]&gt;&lt;/image&gt;&lt;%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%&gt;
&lt;/imageflow&gt;
&lt;%
Recordset1.Close()
Set Recordset1 = Nothing
%&gt;
-------------------------------------
Any advice would be greatly appreciated as I urgently need to get this working ASAP.

Thanks in advance!

Deon

Reply to this topic