Question

asp查询 where后的字段名用变量名替换如何写代码

Answer 1

sql="select * from ziliao where "& skey &" order by jinghao DESC"
skey为条件表达式,如
skey=s1nd&s1yf&s1dw&s1jb&s1sglb&s11jyl&s11jel&s11jsl

s1nd="nd="&snd
其中的snd 是变量,可以设置多个条件

Answer 2

不太清楚你说的什么
<%
'比如下面
sql = "select * from News Where title ='"& Request("title") &"'"
%>
还是
<%
'比如下面
dim ziduan
ziduan = "title"
sql = "select * from News Where " & ziduan & " ='"& Request("title") &"'"
%>