Is there anyway to automate the processs so the Query is run whenever a Login event has occurred.
OR does someone have a better (easier) way to do this?

Thanks

Also can you clarify before I go and mess it up:
You would check the login count in the /includes/a_login.asp page, in the section Check database for matches. (Or am I showing my lack of knowledge here)
Thanks for your help.

A cheesy way I did it was to query the login count AFTER they had already logged in, but BEFORE they were redirected to my main page. Basically, I made an ASP file with this DB query that they just pass through. You do not even notice it unless you have exceeded your login count.

I hope that made sense. Spooky will surely have a better method, but this works for me... for now.

Joe

In the Set SQL String, you could set the top SQL string to :

AND Password='"&T2&"' AND LoginCount < 6"

In the database match, you could try :

Now:
objRs.fields.item(11).Value = objRs.fields.item(11).Value + "1"

Change:
objRs.fields.item(11).Value = objRs.fields.item(11).Value + "1"
LoginCount = objRs.fields.item(11).Value
If LoginCount = 5 then objRs.fields.item(9).value = 0

Its not a very clean way of doing it, I prefer just the SQL.

They would get "details not found" and couldnt log in anyway. Im not sure what deactivating would do any better?

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!