一个SQL的显示问题，被删除出错~

[chong6]

<%
dim str,ors

shoucang="1|2|3|4|5"

Set ors=conn.Execute("select id,userid,uname,content,huifu from ble_topic where id in ("&replace(shoucang,"|",",")&") order by updatetime desc")
do while not ors.eof
str=str&"<li><a href='u.asp?uid="&ors("userid")&"' title='"&ors("uname")&"' class='avatar'>"
ors.movenext
Loop
ors.close
set ors = nothing
str=str&""
response.write str
%>

上面这个代码，是按shoucang的ID来从ble_topic表显示出数据的，但是问题就是，有时候我的收藏是12345，但是刚好4给人删除了，不存在！
导致SQL显示就出错了，那得如何弄？

弄它不存在就显示已被删除呢？

[hookee]

<%
shoucang = "|1|2|3||5| "
Set re = New RegExp
re.Global = True
re.Pattern = "\s+"
shoucang = re.Replace(shoucang, "")
re.Pattern = "^\|+|\|+$"
shoucang = re.Replace(shoucang, "")
re.Pattern = "\|+"
shoucang = re.Replace(shoucang, ",")

Set ors = conn.Execute("select id,userid,uname,content,huifu from ble_topic where id in (" & shoucang & ") order by updatetime desc") 
do while not ors.eof 
  str=str&" <li> <a href='u.asp?uid=" & ors("userid") & "' title='" & ors("uname") & "' class='avatar'>"
  ors.movenext 
Loop 
ors.close 
set ors = nothing 
response.write str 
%>

[fireman_me]

应该不会出错

[Dogfish]

只要shoucang里有validated的数据，你的sql语句就不会出错。

[ACMAIN_CHM]

chong6 (好人帮到底！)
'截至2009-12-19 00:05:34 用户结帖率81.07% 总发帖：206 正常结帖：74 未结帖：39

楼主的贴基本上是无满意结帐了。