Static is REALLY Static!

[Paul W]

In a standalone module (VB) behind my asp.net application, I have a couple
of utility routines that do a simple (fixed) data-retrieval (eg. "select
permissions from tblusers where userid=" & thisuser.

I figured I'd be smart and save multiple db calls for the same page request
by doing:

Function GetPerms() as string
Static myperms as string
if myperms="" then
{get value from db}
myperms=valueFromDb 'store the retrieved data in a Static variable for
use on the next request
else
GetPerms=myperms
endif
End Function

Well, blow me down, I find that the static values persist across different
page requests - even across multiple browser-sessions!!!

Can someone please enlighten me as to what's goin on here?

Thanks,
Paul.

 

[Karl Seguin]

There isn't too much enlightening to do...that's what static is.

It isn't tied to a page request, or a specific user...instead it's tied to
the application domain...You can read more from:
http://www.panopticoncentral.net/archive/2004/04/19/964.aspx

Without knowing much more about what ur doing, I think you'd typically you'd
use something like the HttpCache or Session for what you are trying to
do...

Karl

 

[drjones]

Hi,


for some reason static variables in asp.net have application-wide scope.
It's almost the same as Application("myperms"). You could rewrite your
code:


Private myperms as string
Function GetPerms() as string
if myperms="" then
{get value from db}
myperms=valueFromDb 'store the retrieved data in a Static variable for
use on the next request
else
GetPerms=myperms
endif
End Function




Dr. Jones