conn.execute执行问题

[scabwort]

当执行conn.execute时,为什么直接可以用,像
set rs= conn.execute("select top 10 ntitle,id,ndate from article where nsubname='公告' and id not in(select top 1 id from article where nsubname='公告' order by id desc) order by id desc")
但是把sql放在变量里就不行
像
set sql="select top 10 ntitle,id,ndate from article where nsubname='公告' and id not in(select top 1 id from article where nsubname='公告' order by id desc) order by id desc" '分页查询
set rs= conn.execute(sql)
执行没什么反映
用response.Write(rs.state)也没反映
原来是set rs= conn.execute(sql)之一句后就什么也不执行

请问一下,这是为会

[wcwtitxu]

set sql="....."

sql = "........."

基本类型传递前面不加 Set

[scabwort]

谢谢,平常我还没注意~~