faqts : Computers : Programming : Languages : Asp : ASP/VBScript

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

3 of 3 people (100%) answered Yes
Recently 3 of 3 people (100%) answered Yes

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) & "') "



© 1999-2004 Synop Pty Ltd