Did I miss something or is not possible to use the 3D ImageFlow Gallery dynamically using asp.
On one post I think it says you can using the technique for PHP, I've try this and it dose'nt work, saving the xml as an asp wont allow for a database connection.

Is there a tutorial for asp?



thanks
C

P.S.
Below is the asp page I'm using, all I get in the page with the gallery on it is Undefined.

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connections/myconnect.asp" -->
<
%Dim rsImage__MMColParam
rsImage__MMColParam = "1"
If (Request.QueryString("ref_no") <> "") Then 
  rsImage__MMColParam = Request.QueryString("ref_no")
End If
%>
<
%Dim rsImage
Dim rsImage_cmd
Dim rsImage_numRows

Set rsImage_cmd = Server.CreateObject ("ADODB.Command")
rsImage_cmd.ActiveConnection = MM_AbsolDbCon_STRING
rsImage_cmd.CommandText = "SELECT * FROM machinery WHERE ref_no = ?" 
rsImage_cmd.Prepared = true
rsImage_cmd.Parameters.Append rsImage_cmd.CreateParameter("param1", 200, 1, 50, rsImage__MMColParam) ' adVarChar

Set rsImage = rsImage_cmd.Execute
rsImage_numRows = 0
%>
<imageflow 
	autoFlip="false" 
	flipInterval="3" 
	flipSpeed="1" 
	useMotionBlur="false" 
	dofStrength="0" 
	angle="30" 
	depth="500" 
	spaceMain="225" 
	spaceBack="60" 
	descColor="0xAAAAAA" 
	descSize="14" 
	hasReflection="true" 
	reflectionStrength="30" 
	reflectionSize="80" 
	reflectionBackground="0" 
	startImage="0" 
	imgWidth="266" 
	imgHeight="146"
	quality="2"
	fogStrength="0">
  <title color="0xAAAAAA" size="18"><![CDATA[My Title]]></title>
	<image url="<%=(rsImage.Fields.Item("image1").Value)%>" target="_blank" link="http://www.mydomain.com"><![CDATA[]]></image>
</imageflow>
<
%rsImage.Close()
Set rsImage = Nothing
%>

Edited by - Charlie K on 10 Mar 2009  07:12:12

Hi Charlie,

You lack a repeat region in your fake xml file.
It must look like following:

<title color="0x000000" size="18"><![CDATA[]]></title>
<% 
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) 
%>
	<image url="<%=(Recordset1.Fields.Item("projectimage").Value)%>" target="_blank"><![CDATA[]]></image>

<% 
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  Recordset1.MoveNext()
Wend
%>
</imageflow>

Also did you replaced the Flash variables in the object , embed and param tags in the page on which the 3D Gallery is?

Regards,

Thanks Miroslav, this is what gets put intot he page with the 3D gallery:

  <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="700" height="350" id="ImageFlowGallery1" title="Gallery">
    <param name="movie" value="../imageflowgallery/3DFlowGallery.swf" />
    <param name="wmode" value="transparent" />
    <param name="FlashVars" value="xmlFile=../imageflowgallery/ImageFlowGallery.asp" />
    <param name="quality" value="best" />
<embed src="../imageflowgallery/3DFlowGallery.swf" width="700" height="350" quality="best" name="ImageFlowGallery1" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" wmode="transparent" flashvars="xmlFile=../imageflowgallery/ImageFlowGallery.asp" title="Gallery"></embed>
  </object>

The way I have this working is every machine has 6 images so the eventual contolling asp page would simple have 6 requests to the database asking for image1 to image6 so there is no need to have a repeat region.

Tks
C

I've noticed that the url produced by the image url tag in the dummy xml file is only giving the the path to the upload folder in the domain and not the complete path (www.mydomain.com)

What would I need to add to this line so the browser gets the full path to the image?

<image url="<%=(rsImage.Fields.Item("image1").Value)%>" />

what I need is this... but the syntax is wrong because my asp knowledge to too poor

<image url="http://www.mydomain.com <%=(rsImage.Fields.Item("image1").Value)%>" />

tks
C

Hi Charlie,

We have a video tutorial that shows you how to create a dynamic gallery.

You can find all video tutorials in the "Online Help" tab of www.dmxzone.com/go?13986

Here is also a direct link: www.dmxzone.com/demo/3dflow/dynamicvid/dynamic.htm

Greetings,
George

Thanks for the reply George...

The video is for PHP not ASP and the two don't seem to work the same. Converting an XML file to an ASP in Dreamweaver wont allow connection to a database. As you can see I've created an ASP file and copied the XML generated from the 3D gallery setup into it and explained the problems...

I also purchased 3D Gallery wall as that seem to have more explanation about using dynamic ASP... thus far I cant get that to work either.

C

Hi Charlie,

Were are your image files situated? You don't need to specify an absolute path before binding from the recordset. You can use a relative to root path as well. I.e.:

  <slide url="uploads/"<%=(Recordset1.Fields.Item("PHO_TITLE").Value)%> duration="3" fill="squeeze" background="0x000000">

Regards,