where to store location variable
I have an intranet application that will be used by many users. Each user has one or many locations. The data is dispayed by location, so the user selects which location they are working with from a drop down in the header. Once they select their location, the can begin viewing and updating the data. I store the location in a session variable and use it in all my queries to select only that particular location, or to only insert or update that location. Is the session variable the right thing to use here? I am concerned because the user can leave the computer while filling out a form and come back in an hour or so, and the session variable will have timed out. I cannot default it to anything and they will get an error. Any deas of a better way to store the location?
