I am using a varent from sparty2809 on http://tutorial323.easycfm.com/ It works
great but was created for ACCESS and uses an autonumber datatype. Its great
when you just keep adding advertisments but when you delete one there is now a
gap in the +one ADID (int - identity specification). When the RandRage counts
the MAX ADIDs and then picks a ad. If it hit the number that was deleted it
just shows.. nothing. This is a code breaker for me i cant have gaps.
ADID (int) w/ identity specification +1 //id
CompanyName (text) //name of banner
DatePosted (text) //date posted
HREF (varchar) //link
IMGSRC (varchar) //image source
Views (int) //# of views
Clicks (int) //# of clicks
Type (Text) //flash or image
<!--- Gets Maximum number of ads--->
<CFQUERY DATASOURCE="#Green#" NAME="GetMax">
SELECT Max(ADID) as MaxAD
FROM dbo.banner_left
</CFQUERY>
<!--- RandRange is Random integer between first number and second(1st,2nd) --->
<CFSET ADID = RandRange(1,GetMax.MaxAD)>
<!--- Calls up all columns in table --->
<CFQUERY DATASOURCE="#Green#" NAME="GetADs">
SELECT *
FROM dbo.banner_left
WHERE ADID = #ADID#
ORDER BY ADID
</CFQUERY>
<!--- incrementvalue Adds one to an integer, so it adds one to views--->
<CFSET add = incrementvalue(val(GetADs.views))>
<CFQUERY datasource="#Green#" name="AddView">
UPDATE dbo.banner_left
SET views = #add#
WHERE ADID = #ADID#
</CFQUERY>
<!--- Displays the ad flash or image --->
<cfif GetADs.Type IS "Flash">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0";
width="120"
height="600">
<param name="movie" value="<cfoutput>#GetADs.imgsrc#</cfoutput>">
<param name="quality" value="high">
<embed src="<cfoutput>#GetADs.imgsrc#</cfoutput>" quality="high"
pluginspage="http://www.macromedia.com/go/getflashplayer";
type="application/x-shockwave-flash" width="120" height="600">
</embed>
</object>
<cfelse>
<cfoutput query="GetADs">
<a href="ads\ads_left_out.cfm?ADID=#ADID#" target="_blank">
<img src="ads\images\#imgsrc#" border="0">
</a>
</cfoutput>
</cfif>
I can use the rest of the code. Where do i start from here?
Thank you.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316227
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
