寻找满月 r18唯泉网盘:asp SELECT语句问题

来源:百度文库 编辑:中科新闻网 时间:2024/04/29 02:14:43
sql = "Select * from news where timu_id="&randid,
timu_id为数值型的.假设我又2个timu_id变量,我该怎么写呢?
sql = "Select * from news where timu_id=' & randid & "' and timu_td=' & randtd & "'"
这样写,提示类型不匹配.timu_id是数值型的.

一个值不会等于两个值吧,用OR吧,数值用"",不要再加''.
sql = "Select * from news where timu_id=" & randid & " or timu_td="& randtd & ""