Incrementing a variable in memory

I researched this using a global application variable and that is exactly what I want to do. My problem now is I have no idea how to do that and generate a unique global variable each time since the variable company_id is always random.

Here is my existing code.

**This section queries my database for current advertisers**

<CFQUERY NAME="GRABCOMPANYINFO" DATASOURCE="bg4" cachedwithin="#CreateTimeSpan(0,0,30,0)#">

SELECT      COMPANY_ID, COMPANY, WEBADDRESS, graphic, flashad

FROM         dbo.COMPANIES

WHERE       (COMPANY_ID = #COMPANY_ID#)

</CFQUERY>

**Once it pulls the ad the below code updates the views in the DB.

<cflock name="bannerkingwrite" timeout="10" throwontimeout="no" type="readonly">

<CFQUERY NAME="UPDATEVIEWS" DATASOURCE="BG4">

UPDATE     dbo.BANNERKING

SET        VIEWS=VIEWS +1,MONTHVIEWS=MONTHVIEWS + 1

WHERE       COMPANY_ID = #COMPANY_ID#

</CFQUERY>

</cflock>

What I want to do is to replace the Update Query above with an application variable.  Any idea how I could do that? 

Thanks -

pjlefemine wrote: I have an older application that is querying a list, pulling out an AD from the list, then incrementing the database by +1 with every pull. The site has grown very popular and now the traffic is creating a ton of deadlocks. I tried using CFLOCK but that made things worse. Instead of writing each increment to the DB, I want to write it to memory and then run a routine which collects that value at some interval and update the DB. How would I do this? Would I use an Array or some other method? I am not all that familiar with CF.  Thanks in advance.

A result-set is more or less equivalent to a 2-dimensional array. So you may use an array or a struct to store the data. If the variable involves a user's increment, make it a session variable. Then collect the values within an interval in an application variable, as Dan says.

An application variable might do the trick.