Re: writting to already connected database

From: Andrew Murray (SPAMadBUSTERmurray_at_iinet.net.au)
Date: 05/28/04 

Date: Fri, 28 May 2004 19:01:39 +0800

first up I wouldn't call the table Logins AND the field within that table
Logins.....that would confuse you and probably the script as well.

for example Select * from Table LOGINS where %Login% LIKE <%Login%>

call the field name logged_users or something more descriptive.

(forgive the incorrect code syntax, but you get the idea....)

"John" <anonymous@discussions.microsoft.com> wrote in message
news:94688D11-EB6A-4E13-BB43-6AF0FFCDCCDF@microsoft.com...
> Hello I am having troubles figuring this out. I have a page with a login
script. the login asp script opens a microsoft database a makes sure that the
username and password submited by a form exsist and that they match. After that
the users are allowed to enter the site. What I would like to do is after the
script verifies that the username and password match have it write those values
to a different table in the same database. The name of the table I want to write
to is "logins" and the name of the column inside the table is "Logins". the
reason I need this is I would like to keep track of who logs on and how often. I
only need an example of how to set the first column to write after that I could
figure how to write to different columns and add new variables to submit
,however, I am having trouble just getting the first step done. I am very new to
asp and just trying to get a grasp on it. The script I am using can be seen on
http://www.indywestwrestling.com/new.txt. thanks for any help or comments. John

Relevant Pages

  • Re: aix shell script
    ... > I need a shell script to stop duplicate concurrent logins. ... auth1 = SYSTEM,auth_method ... "root" should be set as an exception to this rule: ...
    (comp.unix.aix)
  • Re: aix shell script
    ... timed log out: ... there is a timed-logout variable for the shell. ... >>I need a shell script to stop duplicate concurrent logins. ...
    (comp.unix.aix)
  • Re: how to migrate users/logins with different domain account
    ... One option is to change domains for the logins using ... sp_revlogin created a script fine. ... 'olddomain' with 'newdomain' is out of the question. ...
    (microsoft.public.sqlserver.security)
  • Re: audit administrator login
    ... You could use this script and put it into a batch file with a list of your computer names passed as the for-next loop. ... Set colListOfServices = objWMIService.ExecQuery _ ... This posting is provided "AS IS" with no warranties, ... what is the best way to audit domain administrator logins, ...
    (microsoft.public.windows.server.active_directory)
  • Re: [Full-disclosure] SSH brute force blocking tool
    ... And just what on God's earth does "SOMEONE LOGGING IN WITH USERNAME SET ... TO A VALID PASSWORD ENTRY" have to do with this script. ... the classic attack is the symlink attack. ...
    (Full-Disclosure)