Question

asp 连接数字型字符串

dim cid
cid=request("a")
sql="select top 10 * from DownloadFiles where FileCheck=true and classid="&cid
我怎么把"order by FileUpTime desc"加到sql语句中呢
cid接收的是数字

Answer 1

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

字符串用 & 或 + 连接

Answer 2

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

Answer 3

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

Answer 4

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