sql = "select * from mytable where id <>0" +sqlsearch + " order by id

set rs = server.createobject("adodb.recordset")
sql = "select * from mytable where id <>0" +sqlsearch + " order by id desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "没有记录"
告诉我下这句话什么意思?sql = "select * from mytable where id <>0" +sqlsearch + " order by id desc"
为什么id<>0"后面还可以加个+sqlsearch, 就这我不懂,

sqlsearch
应该是数值变量
"+变量名+"就是引用数值变量的值
如果是'"+变量名+"'就是引用字符串变量

比如sqlsearch的赋值是2089
哪么0" +sqlsearch + "就相当于02089

说清楚了吗？

sqlsearch是一个变量。 你可以一把 set rs = server.createobject("adodb.recordset") sql = "select * from mytable where id <>0" +sqlsearch + " order by id desc" Response.write(sql) Response.end '看下输入的效果 rs.open sql,conn,1,1 if rs.eof and rs.bof then response.write "没有记录"

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息