Hello all. I was wanting to use a table in my database for temporary storage, and was wondering if it is possible to use the user's session ID as a unique identifier in the table, and then delete the records containing that session ID from the database upon closing the session? If not, is there another practicle way of doing this?

Thanks,

Parallon

Ok, I figured it out. But, I have one question about this. I notice that when I log out, and then log back in, I am issued the same session ID. Is there a way to prevent this? I know that once you close the browser, it is deleted. Does it really matter?

Thanks,

Parallon

the session will be deleted 20 minutes after the browser is closed or after 20 mins with no activity. If you reconnect during the 20 mins with the same browser the same session ID will apply.

I'd do it the other way around, just because the user's unique identifier may not necessarily change. This is why I traditionally don't use it.

I do it like this:

Check for Session ID value (NOT the unique identifier at this stage, I'll explain below):
If no Session ID value, create from database-generated auto number/unique identifier field.

In other words, let your database create the unique identifier by assigning a new record and use THAT as your session identifier. No matter what, it will never be duplicated.