3D ImageFlow Gallery Support Product Page

This topic was archived

Can not make it work dynamically - helllllpppppppp

Reported 01 Jan 2008 06:11:27
1
has this problem
01 Jan 2008 06:11:27 Vitor Fernandes-Neto posted:
Hi George,

i just can not make the 3d flow gallery to work dynamically - with asp.
I started simply like creating with one or two pics without changing to a dynamic and it works fine, but once i change the xml file to 3DFlowGallery1_xml.asp the page which displays the flash wont load.

I have the code in wich page below so you can see and point me what i am doing wrong. cheers.


*****************************************
page name: flash.asp

<%@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>A Galeria da Joana</title>
<style type="text/css">
<!--
body {
background-color: #000000;
}
-->
</style></head>

<body>
<div align="center">
<object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" name="3DFlowGallery1" width="700" height="350" title="A Galeria da Joana">
<param name="bgcolor" value="#000000" />
<param name="movie" value="imageflowgallery/3DFlowGallery.swf" />
<param name="FlashVars" value="xmlFile=imageflowgallery/3DFlowGallery1_xml.asp" />
<param name="quality" value="best" />
<embed src="imageflowgallery/3DFlowGallery.swf" width="700" height="350" quality="best" name="3DFlowGallery1" pluginspage="www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" flashvars="xmlFile=imageflowgallery/3DFlowGallery1_xml.asp" bgcolor="#000000" title="A Galeria da Joana"></embed>
</object>
</div>
</body>
</html>


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

Page name: 3DFlowGallery1_xml.asp

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include file="../Connections/francesca.asp" -->
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows

Set Recordset1_cmd = Server.CreateObject ("ADODB.Command"
Recordset1_cmd.ActiveConnection = MM_francesca_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
%>
*************************************************************

Edited by - vitor123 on 01 Jan 2008 06:12:18

Replies

Replied 01 Jan 2008 07:23:35
01 Jan 2008 07:23:35 Vitor Fernandes-Neto replied:
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_francesca_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
Replied 05 Jan 2008 14:55:04
05 Jan 2008 14:55:04 George Petrov replied:
and why exactly is this Vitor?

Using the DW generated connection include file should be normally just fine..?

George

--------------------------------------------------
George Petrov - Founder of the Dynamic Zones
DMXzone.com, FWzone.net, FLzone.net, CFzone.net,
DNzone.com, FlashFiles.nl
--------------------------------------------------
Replied 06 Jan 2008 09:58:20
06 Jan 2008 09:58:20 Vitor Fernandes-Neto replied:
Hi George,

I really do not know, tried many different ways and none worked, but when i open the connectio within the same page works ok. Fine with me. As long it works its cool.

vitor
Replied 06 Jan 2008 21:41:08
06 Jan 2008 21:41:08 George Petrov replied:
well this is really weird because the include file does exactly the same it includes the connection file - just as it is entered directly into your page.
Then the whole page gets executed - after all the includes are included ...

George

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

Reply to this topic