Hi folks,
I'm doing a simple banner rotator using CF and Flash 4. What I would like it
to do is change the banners dynamically without refreshing the entire page
via meta refresh.
I've seen a few custom tags that do that nicely, but my ISP doesn't allow
custom tags. I could cfmodule it in but then I'd have it in a bazillion
directories and I'd rather not do that.
Any ideas? Is JavaScript the answer here?
Also, I'd like to be able to pass the variables into the Flash, but the only
tutorial I found on this uses Flash5 not 4 so I can't read it.
Code follows for selecting the banners and tracking them. Code modified from
TeraTech ColdCuts.
<!--- Determine number of banners --->
<cfquery name="CountBanners" datasource="MyDatasource">
SELECT Sum(1) AS rnum
FROM Banners
</cfquery>
<cfset R1 = RandRange(1,CountBanners.rnum)>
<!--- Retrieve a banner and assocated link --->
<cfquery name="PickBanner" datasource="MyDatasource">
SELECT RecID, BNRFile, BNRViews, BNRLink
FROM Banners
WHERE (((RecID)=#R1#))
</cfquery>
<cfset NewBNRViews = PickBanner.BNRViews + 1>
<!--- Update the number of views --->
<cfquery name="UpdateView" datasource="MyDatasource">
UPDATE Banners SET BNRViews = #NewBNRViews#
WHERE (((RecID)=#R1#))
</cfquery>
<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="http://active.macromedia.com/flash2/cabs/swflash.cab#version=4,0,0,0";
ID=OFAHBannerAds WIDTH=450 HEIGHT=75>
<cfoutput query="PickBanner">
<PARAM NAME=movie VALUE="#BNRFile#">
<PARAM NAME=quality VALUE=high>
<PARAM NAME=bgcolor VALUE=##FFFFFF>
<EMBED src="#BNRFile#"
quality=high bgcolor=##FFFFFF
WIDTH=450 HEIGHT=75
TYPE="application/x-shockwave-flash"
PLUGINSPAGE="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash";>
</EMBED>
</cfoutput>
</OBJECT>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
