pr3mium
Posts: 31
|
Posted: 02/09/2004, 5:43 AM |
|
I'd like to make an admin interface, so that if the right user opens the page (I have built NT authentication), it adds a row to a specified table with some information. I made a header page, where I put "before show" event with a code like that:
Dim SQL
Dim Connection
SQL = "INSERT INTO Personal_admin (ntname,scala_arv) "&_
"VALUES ('" & getNTname & "','" & scala_arv & "')"
Set Connection = New clsDBdata
Connection.Open
Connection.Execute(SQL)
ErrorMessage = CCProcessError(Connection)
Connection.Close
Set Connection = Nothing
On Error Goto 0
Well, there are no error messages and page is viewed correctly. The variables have their values and everything should be right, but the insert action doesn't take place.
Is it because I'm using "Before show" event? I have no forms in the header, just one label with some HTML content.
Any ideas, how could I define an insert action on page load?
|