Seek help! Question about an ASP array

Brothers. I've just asked this question. What about you playing with us? Looks like you're not going to stick it over there. I'm dizzy.

You use the in statement to denote it. The argument should be a set. However, the collection of ASP is not the same as the collection in SQL. So it's going to be wrong, it's not going to work.

Change it to something like this strsql ="select * from news where 1=0" 'The purpose of 1=0 here is to make the string of the following loop start with or. Otherwise, an error will occur.

for i=1 to ubound(session("lanmu_name"))

Merge into','Management Regulations','Relevant government affairs information','Comprehensive','Such a form.

a=join(session("lanmu_name"),"','")

Handle redundant characters on both sides', and,'The case of only one element needs to be considered separately can be ubound to judge.

a=mid(a,3,len(a)-2)

sql = "select * from news where lanmu_name in (a)

Upstairs can also generate legal character passes, but you'd better bring a sort field order by .But he wrote it wrong, hehe.

rs("per"This is a string that you need to separate and store in an array********************====** as follows:

dim aa,num

set rs="select * from manager where userid='234'")

num =1100

kl=rs("per")

aa = split(k1,",") 'Modify here to separate the string data into an array.

for i = 0 to ubound(aa)if cstr(num)=cstr(aa(i)) then 'Note here that the data types are consistent.

The value is in the array! ")

exit for

end if

nextset rs=nothing

It should be you who define the problem aa = array(kl) to string aa=new arrary(kl).

A one-dimensional array is like a queue.

Whereas, a two-dimensional array is like a phalanx.

This is also due to the fact that the subscript of the array element starts from 0.

For example, the array b(1,3) is a square matrix with two rows and four columns, so the number of elements in the array should be 2*4=8

The subscript starts from 0 by default, the first dimensional upper bound is 1 is 0 and 1 two, the second dimensional upper bound is 3 is 0123 four, with 2 * 4 is 8....

You start with b(0,0).

to your b(x,y).

x-0+1)*(y-0+1) is the number of your array.