怎樣寫sql?

[LONGFOR]

例如:
在部门选择一栏中得到多个部门,以选择的部门做为条件写sql语句,
选择框名:bm
所选择部门:产务部,管理部,业务部
现要在sql中写部门为产务部,管理部,业务部的所有固定资产.
---------得到session(“bm”)为: 产务部,管理部,业务部 -------

[LONGFOR]

sorry,没有说清:
SELECT BM_MC,ZC_MC FROM ZC,BM WHERE BM_DM=ZC_BM AND BM_MC in ( ‘管理部’,’业务部’,’产务部’)' AND YD_RQ BETWEEN '2003-8-1' AND '2003-8-3'


怎样把部门选择得到的BM: 管理部,业务部,产务部(动态的) 转成以上形式,

[cqfeng]

aa.asp
<form method="get" action="bb.asp">
<select name="bm" multiple>
<option value="111">111
<option value="222">222
<option value="333">333
</select>
<input type="submit" value="submit">
</form>

bb.asp
<%
aa=split(request("bm"),",")
bb = " ("
for i=0 to ubound(aa)
bb =bb&" '"&aa(i)&"',"
next
bb = left(bb,len(bb)-1)&")"
sql="select sum([固定资产]) as totalSum from tableName where [部门编号] in "&bb
response.write sql
response.end
%>

[HappyDaemon]

假设数据库里的部门字段为--部门
dim strSQL
strSQL= Trim(session(“部门”))
strSQL= Replace( strSQL, "," , "'or 部门='" )
strSQL= "select sum(固定资产) from 表 where 部门='" & strSQL & "'"

[LONGFOR]

显示是:
select CZ_RQ,BM_MC,CZ_SL from CZ,BM WHERE BM_DM=CZ_BM AND YD_RQ BETWEEN '2003-8-1' AND '2003-8-3' AND BM_MC in )

[zhxhjj]

select * from table where deparment like '%"&session("bm")&"%'

[zhxhjj]

deparment=split(session("bm"),",")
for i=0 to ubound(deparment)
aa=aa+"'"+deparment+"',"
next
aa=left(aa,len(aa)-1)

sql="select....and bm_mc in ("&aa&")..."

[Brookes]

bm="'" & replace(trim(request("bm")),",","','")&"'"
sql="SELECT BM_MC,ZC_MC FROM ZC,BM WHERE BM_DM=ZC_BM AND BM_MC in (" & bm & ")' AND YD_RQ BETWEEN '2003-8-1' AND '2003-8-3'"

[LONGFOR]

zhxhjj(寻找圣源[寻圣者]) :
select * from table where deparment like '%"&session("bm")&"%'
不可取,资料会有不精确

[LONGFOR]

to:Brookes(边走边唱)
------------------------------------------------
result:
select CZ_RQ,BM_MC,CZ_SL from CZ,BM WHERE BM_DM=CZ_BM AND CZ_RQ BETWEEN '2003-8-1' AND '2003-8-3' AND BM_MC in ('')
-----------------------------------------------------------------------

to: zhxhjj(寻找圣源[寻圣者])
error......型态不符合.

[LONGFOR]

ok!Thank you!

[cullstar]

LONGFOR(雪婷) ,好名字，我喜欢！：）

bm="'" & replace(trim(request("bm")),",","','")&"'"
sql="SELECT BM_MC,ZC_MC FROM ZC,BM WHERE BM_DM=ZC_BM AND BM_MC in (" & bm & ")' AND YD_RQ BETWEEN '2003-8-1' AND '2003-8-3'"