Entry

how do i use the contents of an array stored in a session variable as the criteria in a SQL statemen

Jul 23rd, 2003 00:05
Maggie Chao, nadhiesh kariapperuma,

You can't use arrays stored in a session variables directly.  Instead, 
do something like this:
ary1 = Session("ary1")
strSQL = "select COL1 from TABLE1 where COL2 in ('" & ary1(0) & "', '" 
& ary(1) & "') "