关于分类查询的一个问题

[zeoyeah]

我想实现如下功能:

"sql= select * from table where key=" &keyword&

我是让它以不同的字段进行查询,key就是字段名,keyword就是用户查询输入的文字,前面的条件不知道

如何加上去,现在我有四个字段:name,company,orderid,title,不知道如何编写前面的条件,帮帮小弟!

谢谢!

[jbj001]

sql= select * from table where key like '%"&keyword&"%' and name like '%"&request("name")&"%' and ....

[baisun]

sql= select * from table where key like '%"&keyword&"%' or name like '%"&request("name")&"%' or ....

[smadsl785]

sql="select * from table where "&key&"='"&keyword&"'"

[underone]

strSql="SELECT * From table Where 1=1 ";
if ( keyword!= "" ){
strSql += " AND keyLIKE '%" + request("keyword")+ "%'";
}
if ( name!= "" ){
strSql += " AND name LIKE '%" + request("name")+ "%'";
}
if ( company!= "" ){
strSql += " AND name LIKE '%" + request("company")+ "%'";
}
if ( orderid!= "" ){
strSql += " AND name LIKE '%" + request("orderid")+ "%'";
}
if ( title!= "" ){
strSql += " AND name LIKE '%" + request("title")+ "%'";
}

[zeoyeah]

谢谢大家,我自己想出了一个好办法
keyword=trim(request("keyword"))
key=request("select")

select case key
case 1
sql="select * from data where lxr='"&keyword&"'"
case 2
sql="select * from data where name='"&keyword&"'"
case 3
sql="select * from data where id="&keyword
case 4
sql="select * from data where title='"&keyword&"'"
end select

[zeoyeah]

不过认为好,是我自己认为的,请大家指点!

[hreoghost]

踩个脚印...

继续革命~~~~