Hello all.

I am using a temp table, and I would like the values in that table containing the users 'UserName' and 'SessionID' to be deleted upon page load, because the following page will insert data into that table with the 'UserName' and a new 'SessionID'. How would I go about doing this?

Thanks,

Parallon

After your connection string use this sql statement to remove all records in the table.

DELETE FROM tablename

ack, that code will remove everything. put a WHERE clause in there!

DELETE FROM table WHERE sessionID = 51928

bwaha, i guess it would help if I slowed down and read everything clearly.

what database are you using?

Currently I am using Access, but will probably upgrade to SQL once I get this application finished. Also, I am creating most of this application using some of Dreamweaver's built in functions on top of ASP/VBScript, so I am a little confused exactly where to put it. Hope this helps.

Thanks,

Parallon

This is the entire code with the connection and everything. It may or may not work. It depends on your server configuration. This is a pretty generic set up so hopefully it will work.

It should go at the top of the page after your asp declaration statement and before your opening html tag. (If you have another script running for security or session, etc. then it would go after that, but still before you html.)

<%
Dim oConn, oRS, sQry
Dim sConn

set oConn = Server.CreateObject("ADODB.Connection")
'Relpace Xxxxx with the name of your dsn
sConn = "Data Source=Xxxxx;"
oConn.Open sConn
Set oRS = Server.CreateObject("ADODB.Recordset")
Set oRS.ActiveConnection = oConn

'SQL RecordSet 
'Change tablename to the name of the table in your database
sQry = "DELETE FROM tablename"

oRS.Open sQry

%>

Thank you VERY much. That worked perfectly, although I had a little trouble adding in a variable into the WHERE clause, but I finally got it with:

 
sQry = "DELETE * FROM Temp_Date WHERE UserName =  '" & SesUserName & "' "

Works like a charm.

Thank you again,

Parallon