<cfquery datasource="blah" username="user" password="pass"
name="addclickthrough">
UPDATE NetReferrers
SET ClickThroughs = (SELECT Info.ClickThroughs
FROM Info.NetReferrers
WHERE PromoID = '#URL.Promo#')
#Info.ClickThroughs# + 1
WHERE PromoID = '#URL.Promo#'
</cfquery>
Am i doing this right, or am i just not thinking correctly today???
Thanks,
Kevin
~~~~~~~~~~~~~~~~~
Kevin Mansel
Web Developer
Fox Communications
[EMAIL PROTECTED]
<<Kevin Mansel.vcf>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
