type mismatch and session variables

[s_m_b]

I am having a problem with a page that creates a treeview from a database,
by reloading itself on each request for a new folder to be explored.
The problem revolves around using an array to store the data, that is
copied to a session variable, and reloaded from that with each new view.
That is, on first opening the page, the array is created and populated,
then copied over; subsequent reloads of the page load the session variable,
rather than create the array. This is where the problem lies - by DIMing
the array, the first load of the page is fine, but a type mismatch pops up
when the session is pulled in to the array name; not DIMing the array, the
first load fails due to not declaring the array.

Currently the ony way I have round the problem is to switch option explicit
off and not DIM any variable. If there was a way to have the session
variable and array co-exist to start with, that would be good.

TIA

[Aaron Bertrand [SQL Server MVP]]

I always bring arrays local before referencing them. This might help a
little bit (though not directly related):
http://www.aspfaq.com/2524


"s_m_b" <sm********@hotmail.com> wrote in message
news:Xn**********************************@207.46.2 48.16...

I am having a problem with a page that creates a treeview from a database,
by reloading itself on each request for a new folder to be explored.
The problem revolves around using an array to store the data, that is
copied to a session variable, and reloaded from that with each new view.
That is, on first opening the page, the array is created and populated,
then copied over; subsequent reloads of the page load the session
variable,
rather than create the array. This is where the problem lies - by DIMing
the array, the first load of the page is fine, but a type mismatch pops up
when the session is pulled in to the array name; not DIMing the array, the
first load fails due to not declaring the array.

Currently the ony way I have round the problem is to switch option
explicit
off and not DIM any variable. If there was a way to have the session
variable and array co-exist to start with, that would be good.

TIA