New Idea for name stamp question?

[jleiker]

So after exhausting the idea of username on my other thread....I 'do' have session variables from the login to the database. I have an open field in the table called "verifyid" which I would like to hold the username below. How do I insert these in from the session?. Here's what I have on my form response currently:



Password=Session("password")
Username=Session("username")



Set conn = Server.CreateObject("ADODB.Connection")

conn.connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Password='"& Password & "';User ID='"& Username &"';Data Source=tables.mdb;Persist Security Info=True;Jet OLEDB:System database=\supportworkgroup.mdw;"

set rs=Server.CreateObject("ADODB.Recordset")
conn.open




SQL = "INSERT INTO tblPRODUCTIONERROR (`Error Type`,`employee#`, `Date of Error`,`ynreviewed`,`ynvalderror`) VALUES ('" & ErrorType & "', '" & EmployeeNum & "', '"&Dateoferror&"','"& ynreviewed &"','"& ynvalderror&"')"

rs.Open sql, conn

etc.

[jleiker]

I got it! finally. I appreciated everyone's response on this. I still think there is a different way to do this but I can work with this.