RE: [CFTALKTor] Updating counter values

[Athena Janiszewski]

If what you're looking for is:

 

<CFQUERY NAME="UpdateCounter" DATASOURCE="DB">
UPDATE TABLE2
SET ReviewCount = #NewValue#
WHERE CheckID IN (#checkCategory.CheckIDs#)
</CFQUERY>

 

You would have to make #checkCategory.CheckIDs# a list containing the IDs of all the records you would like to change. So for you, (#checkCategory.CheckIDs#) would equal "1,2,3".

 

<CFQUERY NAME="UpdateCounter" DATASOURCE="DB">
UPDATE TABLE2
SET ReviewCount = #NewValue#
WHERE CheckID IN (1,2,3)
</CFQUERY>

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Arun Persaud
Sent: Thursday, April 18, 2002 7:14 PM
To: [EMAIL PROTECTED]
Subject: [CFTALKTor] Updating counter values

I've been racking my brain for the past hour. I'm having trouble updating the values for each record in  COLUMN 3 all at once:

 

 

TABLE2:COLUMN 1
CheckID (autonumber) 
1       
2        
3

 

TABLE2:COLUMN 2
Reviews  (int)
4        
2        
7 
     
TABLE2:COLUMN 3
checkReviewCount (int)
0
0
0

 

 

This is the Query that I'm using:

 

<CFSET NewValue = #checkCategory.ReviewCount# + 1>

<CFQUERY NAME="UpdateCounter" DATASOURCE="DB">
UPDATE TABLE2
SET ReviewCount = #NewValue#
WHERE CheckID = #checkCategory.CheckID#
</CFQUERY>