Question

在sql中查询出5条记录并将他们的id保存在一个变量里

比如我的数据库里有5条记录，我将他们查询出来，然后用一个变量保存所有的id像这样：sumid=1,2,3,4,5 sumid是变量,后面的5个数字是id值,(asp网站)set rs=server.CreateObject("adodb.recordset")
sql="select * from Lei "rs.open sql,conn,1,1
counts=rs.recordcount
for i=0 to counts
aaa(i)=rs("Lid")
next
response.Write aaa(i)
rs.close
set rs=nothing上面是我用数组做的，可是说aaa类型不匹配

Answer 1

for i=0 to counts
ii=ii+rs("Lid")+"|"
next
aaa=split(ii,"|")for j=1 to countsresponse.write aa(j)next

Answer 2

dim aaa()set rs=server.CreateObject("adodb.recordset")
sql="select * from Lei "rs.open sql,conn,1,1
counts=rs.recordcount
for i=0 to counts
aaa(i)=rs("Lid")
response.Write aaa(i)next
rs.close
set rs=nothing

Answer 3

Dim aaa()
set rs=server.CreateObject("adodb.recordset")
sql="select * from Lei "
rs.open sql,conn,1,1
counts=rs.recordcount
for i=0 to counts - 1
ReDim Preserve aaa(i)
aaa(i)=rs("Lid")
next
response.Write aaa(i)
rs.close

Answer 4

强制转换一下？aaa(i)=CINT(rs("Lid"))