有个数组a(i),里面有数据1,2,3.....,求知的。
现想嵌入到sql语句中,即是:
sql="select * from tb where tid in( ) "
in()里面的就是数组里面的数据1,2,3...请问应如何连接字符串?
才可以转成允许的格式,即:
sql="select * from tb where tid in(1,2,3,......)
现想嵌入到sql语句中,即是:
sql="select * from tb where tid in( ) "
in()里面的就是数组里面的数据1,2,3...请问应如何连接字符串?
才可以转成允许的格式,即:
sql="select * from tb where tid in(1,2,3,......)
s=join(a,"','")
s="('" & s "')"sql="select * from tb where tid in " & s
来了,YEAR!
这样就行了,试一下!
~·~
然后在两边加上括号就行了,注册看看最后面是否有多余的逗号!!有的话处理掉就行了!!
'自己改一下Dim a(4) As Integer
Dim k As String
Dim I As Integer
k = ""
a(1) = 1
a(2) = 2
a(3) = 3
a(4) = 4
For I = 1 To UBound(a)
k = k & a(I) & ","
Nextk = Left(k, Len(k) - 1)