#@_@ 求救 @_@ 用checkbox选中多项做更新操作```请大侠过来看看,非常感谢 @_@

[hreoghost]

用checkbox选中多项做更新操作```

现在得的的ID是这样的```
sql1="select * from tb where sid in('7259222297,533383679058')"

现在要怎么变成
sql1="select * from tb where sid in('7259222297','533383679058')"

也就是说括号里要用单引号分开 ,不然更新不了```

<input name="checkid" type="checkbox" id="checkid" value="<%=cstr(rs("sid"))%>">

--------代码如下--------------------------------------------------------
dim id
id=trim(request("checkid")) '从上一页得到的CHECKBOX选中的项

action=request("action")
if request("action")="modify" then
sid=request("id")
pp=trim(request("pp"))
dim rs1,sql1
set rs1=server.CreateObject("adodb.recordset")
sql1="select * from tb where sid in('"&sid&"')"
rs1.open sql1,conn,1,3
response.write sql1
do while not rs1.eof
rs1("p_times")=p_times
rs1("pp")=pp
rs1.update
rs1.MoveNext
loop
response.write ("恭喜您，修改成功!!!")
end if
-----------------------------------------------------
请看看要怎么办?

[daniel206]

这样就行了
sql="select * from tb where sid in('"&jion(split(sid,","),"','")&"'"

[k_lyh]

上面的仁兄可能是直接写出来没调试，有点小错误，在下稍做修改。

<%
sid="'7259222297,533383679058,533383679058'"

sql="select * from tb where sid in("&join(split(sid,","),"','")&")"

response.write sql
%>

[zhanghongwen]

不错,用SPLIT()函数分开就行了.

[hreoghost]

还是有点问题````

---------------------------------------------------------------
sql1="select * from tb where sid in("&join(split(sid,","),"','")&")"
Microsoft OLE DB Provider for SQL Server (0x80040E14)
第 1 行: ',' 附近有语法错误。
---------------------------------------------------------------
sql1="select * from tb where sid in("&join(split(sid,","),"','")&")"
Microsoft OLE DB Provider for SQL Server (0x80040E14)
第 1 行: ',' 附近有语法错误。
---------------------------------------------------------------
sql1="select * from tb where sid in(‘"&jion(split(sid,","),"','")&"'"
Microsoft VBScript 运行时错误 (0x800A000D)
类型不匹配: 'jion'
---------------------------------------------------------------

[jspadmin]

str1="'7259222297,533383679058'"
str2=replace(str1,",","','")
sql1="select * from tb where sid in(str2)"

[jspadmin]

而且，用join的话，也要注意不是jion,是join

[hreoghost]

上面的大侠,用这样的话可以
str2=replace(sphoneid,",","','")
sql1="select * from prize where sphoneid in('"&str2&"')"

write出这个语句
select * from prize where sphoneid in('59587259297 ',' 59183679058')

但是只能更新'59587259297 这条记录```

sql1="select * from prize where sphoneid in('59587259297','59183679058')"
我用数字调试写这样就可以更新多条``

等会,再看下``

[hreoghost]

问题解决了```

在逗号二边直接多一个空格就行了``

下面是正确答案```

散分````
---------------
str2=replace(sphoneid," , ","','")

sql1="select * from prize where sphoneid in('"&str2&"')"