SQL ISSUE.. PEEPS

Dim iStaffID              'as integer
Dim strUser          'as string
Dim strSQL               'as string

iStaffID = request.querystring("StaffID")
strUser = Request.Servervariables ("LOGON_USER")

strSQL = "INSERT INTO dbo.viewed (userID, staffID) _
                 Values ('" & strUSer & "'," & iStaffID & ")"

Conn.Execute (strSQL)

You don't need to pass getdate(). Just set the default value of that column to GetDate(), and it will be added automatically when you insert the record. This is assuming that the database server holds the correct time.

If not pass it now(), which gets the current time, in ASP, from the web server.

Cheers,
Andrew