ASP中查询字段动态改变，查询条件动态改变 如何实现（急）

[hemingway22]

通过复选框的选择来决定是否select 后面跟的字段
如何实现
例如复选框控件包括workcode,resourcename,sex等
选中workcode,workresource,
则提交页面后，要生成的sql查询语句
sql ="select "
if request.form("workcode") <> "" then
sql = sql & "hrmresource.workcode,"
end if
if request.form("resourcename") <> "" then
sql = sql & "hrmresource.resourcename,"
end if
if request.form("sex") <> "" then
sql = sql & "hrmresource.sex,"
end if

我想要的结果是选中复选框就生成的sql语句例如“select workcode,resourcename”
写程序过程中，老是遇到问题，请高手指点

[hookee]

<%
sql ="select " 
f = ""
if Trim(request.form("workcode")) <> "" then  
  f = f & "hrmresource.workcode," 
end if 
if Trim(request.form("resourcename")) <> "" then 
  f = f & "hrmresource.resourcename," 
end if 
if Trim(request.form("sex")) <> "" then 
  f = f & "hrmresource.sex," 
end if
If f = "" Then
   f = " * "
Else
   f = Left(f, Len(f)-1)
End If

sql = sql & f & " FROM tbl"

%>

[number123456]

如果是想通过选框来实现不同字段的查询，如下

column = request.form("sex")
sql = "select * from table where "&column&" like '%"&key&"%'"

如果你是想通过选框来实现输出不同的字段可以如下

sql ="select id,"'预备一个必要输出的字段，如ID 
if request.form("workcode") <> "" then  
  sql = sql & "hrmresource.workcode," 
end if 
if request.form("resourcename") <> "" then 
  sql = sql & "hrmresource.resourcename," 
end if 
if request.form("sex") <> "" then 
  sql = sql & "hrmresource.sex," 
end if 

[chengguandong]

那个很简单，我已经研究出来了。QQ:308046190

[qq392225453]

二楼的比较牛逼