这ASP句子为啥报错呀!请教了!!

[fangxianghua9801]

<%@ language=vbscript %>
<%
dim StrId
'接收ID
StrId=trim(request("itemno"))+","
Session("StrId")=StrId
if len(Session("StrId"))<>0 then
getID=Session("StrId")
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&Server.MapPath("myDB/Datasource.mdb")
sql = "select * from Products where ID in ('"+getID.Substring(0,getID.Length-1)+"')"
set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open sql,conn,1,1
%>
特别是这句:sql = "select * from Products where ID in ('"+getID.Substring(0,getID.Length-1)+"')"可能有错,我把它注释成这样是行的"select * from Products "'where ID in ('"+getID.Substring(0,getID.Length-1)+"')"
我主要想实现这样的SQL效果:select * from Products where ID (2,10,7,9)

[fangxianghua9801]

ding

[fangxianghua9801]

Jaron、possible help

[gxh7506]

试试这样:
sql = "select * from Products where ID in ('"&(getID.Substring(0,getID.Length-1))&"')"

[fangxianghua9801]

gxh7506(潇湘水云)兄不行呀

[pzhuyy]

在查询分析器里面测试一下，或者在程序中把表达式改为那几个值，多试几次就知道问题出在那儿了！