"Sean" <NO************ *****@optusnet. com.au> wrote in message
news:Oc******** ******@tk2msftn gp13.phx.gbl...
HI,
I have a shopping cart in which I am trying to use breadcrumb style
navgiation. I need to be able to display the categroy heading relating to
the section of the site a visitor is using i.e If a user is in the
"camera" section I need to display that heading as a link "camera", however in
order to do this at the moment I am querying the database and storing the
recordset in the application object (see below). I should imaging there is
a much better way of doing this, if there is can someone help me out with
some code?
Sean
SQL = "SELECT Catid,catDesc,P arentCatid FROM product_categor ies WHERE
Catid=" &pCatId
set rs = db_conn.execute (SQL)
Application("Ca tegoryName") = rs(1).Value
Im not sure what your aim is,
but
A Application("Ca tegoryName") variable is the same for all users, so if one
user changes the variable from 'camera' to 'film', the value will change for
all users no mater if they are in the camera or film or what ever section.
this value stays till changed or site is restated.
For example, if you were running a action, you would want the latest bid to
be seen bid to be seen by all users
to avoid the chance that 2 users may use the variable at the same time, use
Application.Loc k and Application.Unl ock when you change a Application
variable
A Session("Catego ryName") variable is for the user only, and lasts as long
as the session, if you close the browser you lose the values. You can leave
the page as long as you come back before the session times out default is 20
minutes
a normal DIM CategoryName variable loses its value as to leave the page.
