Re: passing user info on each page
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30035
interpreted = N
texte = At 1:14 PM 4/5/00, dale@gmr.dresdner.net wrote:...>Maybe instead of doing a [search], create a temp database with a session ID,>user level (pulled from the main database initially) and time/date stamp,>then simply do a [lookup] on the unique session ID to pull the level. Then>have a trigger to clean up this temp database every few hours?One a similar site (you know the one I'm talking about) we do our own authentication of the user against the members db, assign a cart number and create a session record for the user in a sessions db. We do pass the session id which is really a cart value in the URL, sorry. But we don't call it a cart, we call it sid for session ID. You can call it whatever you want. The session record is stuffed with a number of fields such as name, level, status, date and time created, etc.On every page, there is an include file which: a) makes sure there is an sid, b) check the date and time on the sid and if expired, redirects to the login page, c) checks the user level for enabling various menu options or other features for that page.So that's one db lookup (based on session id) on every one of the 100,000 page views a day. Heck we even do a banner ad database operation on every page too, and on a 300MHz blueG3 doing lots of other stuff, we're barely breaking a sweat.___Joe___ (MisterYouKnowWho)_________________________________________________Joseph D'Andrea JoeDan@West21.comWEST21.com Internet services for the 21st Century http://www.west21.com/_________________________________________________-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
At 1:14 PM 4/5/00, dale@gmr.dresdner.net wrote:...>Maybe instead of doing a [search], create a temp database with a session ID,>user level (pulled from the main database initially) and time/date stamp,>then simply do a [lookup] on the unique session ID to pull the level. Then>have a trigger to clean up this temp database every few hours?One a similar site (you know the one I'm talking about) we do our own authentication of the user against the members db, assign a cart number and create a session record for the user in a sessions db. We do pass the session id which is really a cart value in the URL, sorry. But we don't call it a cart, we call it sid for session ID. You can call it whatever you want. The session record is stuffed with a number of fields such as name, level, status, date and time created, etc.On every page, there is an include file which: a) makes sure there is an sid, b) check the date and time on the sid and if expired, redirects to the login page, c) checks the user level for enabling various menu options or other features for that page.So that's one db lookup (based on session id) on every one of the 100,000 page views a day. Heck we even do a banner ad database operation on every page too, and on a 300MHz blueG3 doing lots of other stuff, we're barely breaking a sweat.___Joe___ (MisterYouKnowWho)_________________________________________________Joseph D'Andrea JoeDan@West21.comWEST21.com Internet services for the 21st Century http://www.west21.com/_________________________________________________-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Joseph D'Andrea
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Start an application on NT? (1999)
Another Large Database Questions (1997)
Macauth: Dates and No Scripting... (1997)
[WebDNA] TCPConnect assist (2016)
WebCatalog v2.1.1 (1998)
foriegn characters and webcatalog (1997)
NT lockup (1998)
Append..... doesn't (2000)
What kind of request is this? (2002)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Any WebCatters going to CeBit in Hanover, Germany? (2000)
Three new problems, maybe a fourth (1997)
Email Set-Up? (1997)
Syntax of a URL for including ?cart=[cart] and #something? (1998)
Emailer update for Mac? (1998)
taxTotal (1997)
Modifying order output (1997)
Prices Dropped (1998)
Protect (1997)
getchars broken? (1997)