Counting users visits

[gmagerr]

I did find something on this in the threads, but i am a total dork when it comes to actually picking the booger once someone puts my finger there for me
Could someone once and for all clear this up for me. i'm using UltraDev 4, I have a database called TelmonIntranet and a table called IntranetAccounts. In that table i have a field called TotalLogins. Now how (in great booger picking detail) can i increment this TotalLogins field by 1 each time a user logs in.
Thanks in advance guys, this is a great forum

 

[vasah20]

is your database SQL Server or access? if it's SQL Server, create an SP to do the incrementing for you. if it's access you need to do it in the ASP code.

basically, you would "select max(totallogins) as total from intranetaccounts", increment that number by one, then reinsert it.

In SQL Server (or any DBMS that supports stored procs), its a lot more elegant and efficient, but that's not to say that it can't be done using Access/ASP.

here's an ex, in Access/ASP:
'assume conn = your connection
Dim cnt
set rs = conn.execute("SELECT MAX(totallogins) AS total FROM intranetaccounts&quot
cnt = rs("total&quot + 1
conn.execute "INSERT INTO intranetaccounts (totallogins) VALUES (" & cnt & &quot"

that'll increment the count for you, using just ASP. In SQL Server, just adapt the two statements into your login proc (you do have a login proc, don't you? ) and you're done.

hth

leo

------------
Leo Mendoza
lmendoza@students.depaul.edu

 

[ToddWW]

Leo,

Do you mean UPDATE instead of INSERT.

ToddWW