Unique ID for Every Session 1

[bowettwow]

Dear All,

When someone logs on to my transactional site I want to assign them an "Order Number" (which is unique) when they start a session. I assume I need some code in my Global.asa. Whats the easiest way to do this.

Cheers,

BowettWow.

 

[mwolf00]

why not use the session id that asp creates for each session - session.sessionID?

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[onpnt]

the sessionID value will give you this

____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924[/sub]

http://www.onpntwebdesigns.com

 

[bowettwow]

Will the SessionID always be unique or will it repeat ID's over a period of time (perhaps after a restart of the server)?

 

[mwolf00]

They are unique

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[bowettwow]

I dont mean to press this point but I've just read in a book on ASP that:

"the session ID should not be used as a primary key in a database because because it may not always be unique. For example if the Web Server is restarted, the server may assign a sessionID that was previously assigned to a different user."

Has IIS changed in recent versions to correct this? Any thoughts?

 

[corneI]

Please correct me if i'am wrong but I do try
I have never done this before but here goes!!!!!!!!

In the global asa put the following sub:

Sub Session_OnStart

end sub

This will be run when a new session is created.
Then create a text file which contains a 0

Then use the file system object in the sub to read from the text file. After it has been read cast it to a Long.This will be you id.Then assign it to a session variable.
Write this value back after you have incremented it to the text file after you have deleted the old one.
Well thats sort of the what I think should happen.
Hope it works!

Corne'
#-)

 

[bowettwow]

Sometimes the simple solutions can be the best

 

[onpnt]

bowettwow
you had not mentioned anything in regards to a database prior to the last post. although I think the chances of the sessionID being duplicated are slim to none it would be senseless to use anything but a autonumber for your primary ID in the DB. That is what it is for! It's safe, stable and conventional database design.



____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-3811[/sub]

http://www.onpntwebdesigns.com

 

[corneI]

bowettwow : If you have a Database, onpnt's idea will definatly work the best. It will cut the overhead of reading and writing to the text file as well as the creation of the FSO object.100% faster and safer.

Corne'
#-)

 

[bowettwow]

But how would I pass the unique id to a session variable from an autonumber in my database. I'd somehow have to add a record to the database and then read what autonumber the database assigned it - how could I do this?

 

[corneI]

bowettwow:
You don't have to add a new record to the table just add 1 to the last recordnumber.

Maybe somebody knows a quick way to do this so that you don't have to query the database for the last record?

Corne'
#-)