Hello,
     I'm trying to write the code for a website that I want to upload to a paid server for my new talent agency. I need to have a variable running on the server that sets my Talent ID# and keeps counting it just like autonumber in Microsoft Access. Do I have to cfset the variable or how can I do this so the variable doesn't reset to 0 everytime the page expires?

Respectfully submitted,
Larry V. Reitz, Jr.

Hi there,

You may want to take a look at the following two articles. They describe a Hit Counter scenario, implemented in ASP. There are no Cold Fusion versions of these articles available, but these articles may give you enough ideas to implement a similar solution in CF.

http://Imar.Spaanjaars.Com/QuickDocID.aspx?QUICKDOC=227
http://Imar.Spaanjaars.Com/QuickDocID.aspx?QUICKDOC=238

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

*** The problem is that I am a student and I have only had one class in Cold Fusion. I am taking 8 week classes which is not enough time to fully learn all this code. *** Respectfully submitted,
Larry V. Reitz, Jr.

Well, I never said you should learn all that code; I said the articles could give you some ideas how to implement this in Cold Fusion.

Basically, the idea *is* the same: store a global number somewhere in memory and in a text file or database. Each time the number gets increased, you should also update the number in the file or database.

Alternatively (and more safe in your situation), have the database hand out an AutoNumber. For each new ID you need, insert a record in a specific table. Let the database assign a new ID for the record and use that ID as your ID. If you search Google, you'll find numerous examples of Cold Fusion code that uses a database.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.