Number of times visited

[ed@oac]

I am using Coldfusion with Microsoft Access database integration to create
applications. I am in desperate need for appropriate Coldfusion code so that
each time a registered user logs in the database keeps a record of how many
times the registered user has logged in.

The key issue here is (I think) getting a cell number in Access to update
itself, which obviously means having the right instruction from a Coldfusion
webpage. I am sure it is simply!!??

I would be extremely pleased if someone can put me out of my misery.:heart;

[ed@oac]

I am using Coldfusion with Microsoft Access database integration to create
applications. I am in desperate need for appropriate Coldfusion code so that
each time a registered user logs in the database keeps a record of how many
times the registered user has logged in.

The key issue here is (I think) getting a cell number in Access to update
itself, which obviously means having the right instruction from a Coldfusion
webpage. I am sure it is simply!!??

I would be extremely pleased if someone can put me out of my misery.:heart;

[philh]

Hi ed, Say you have a table in your MDB called tblLogins. It consists of a
primary key field, a field to hold the user's ID (userID), and an integer field
(LoginCount). Populate the table with your registered user IDs. Add code to
your registration process to make sure that new users are added. Upon a
successful login, issue the following code: <cfquery name='incrementLogin'
datasource='#MyDSN#'> UPDATE tblLogins SET loginCount = loginCount+1 WHERE
userID = '#whateversessionvariableyouusetoidentifytheuser#' </cfquery> HTH,

[ed@oac]

Marvellous!!! Many thanks for your help!

It's easy when you know how!