asp 连接数字型字符串

来源：百度知道 编辑：UC知道 时间：2024/06/08 18:08:08
dim cid
cid=request("a")
sql="select top 10 * from DownloadFiles where FileCheck=true and classid="&cid
我怎么把"order by FileUpTime desc"加到sql语句中呢
cid接收的是数字

sql="select top 10 * from DownloadFiles where FileCheck=true and classid="&cid &" order by FileUpTime desc"

字符串用 & 或 + 连接

sql="select top 10 * from DownloadFiles where FileCheck=true and classid="&cid &" order by FileUpTime desc
如果不是数字就

dim cid
cid=request("a")
sql="select top 10 * from DownloadFiles where FileCheck=true and classid="&cid order by FileUpTime desc

sql="select top 10 * from DownloadFiles where FileCheck=true and classid="&cid &" order by FileUpTime desc"