28,391
社区成员
发帖
与我相关
我的任务
分享如何输入把数组中对应的值输出来
用户表
ID Name
1 Sally
2 Dean
3 Holly
4 Divided
5 Jack
6 Peter
数组 arid={1,3,4}
想要的结果是sally，holly, Divided
我该如何操作啊？
ID Name
1 Sally
2 Dean
3 Holly
4 Divided
5 Jack
6 Peter
数组 arid={1,3,4}
想要的结果是sally，holly, Divided
我该如何操作啊？
...全文
请发表友善的回复…
发表回复
sallyimportant 2011-09-08
- 打赏
- 举报
好的，先谢谢啦，我去试试了
xiawaner 2011-09-08
- 打赏
- 举报
dim ar,str
ar = array(1,2,3)
for i=0 to ubound(ar)
str = str & ar(i) & ","
next
if str <> "" then
str = left(str,len(str)-1)
end if
sql = "select * from table where id in ("&str&")"
ar = array(1,2,3)
for i=0 to ubound(ar)
str = str & ar(i) & ","
next
if str <> "" then
str = left(str,len(str)-1)
end if
sql = "select * from table where id in ("&str&")"
