Basically, i am trying to grab the value that is currently in the table, and
then add 1 to it without going through another CFQUERY statement, I am not
doing this right, but for some reason i cannot see the right path to
take....??????
-----Original Message-----
From: Terry Bader [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 11:59 AM
To: CF-Talk
Subject: RE: cf query?
is PromoID a number based type in the db or a char?
you are treating it as a char based datatype...
Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]
(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487 aim: lv2bounce
http://www.cs.odu.edu/~bader
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 19, 2001 2:32 PM
> To: CF-Talk
> Subject: cf query?
>
>
> <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
