ASP网页查询问题

[wuweijun0223]

SELECT EMP_CODE, EMP_NAME,time_beg,time_end,chk_days,chk_hour,type_id,remark
FROM dbo.mt_vacation,dbo.mt_personms
WHERE dbo.mt_vacation.empindex=dbo.mt_personms.empindex and EMP_CODE = 'MMColParam' and type_id='MM'

dbo.mt_vacation,dbo.mt_personms是两个表
EMP_CODE = 'MMColParam'员工卡号列名和变量名
type_id='MM'请假类型列名和变量名

当变量MM为空时，如何查询这个条件的全部值

[wzhiyuan]

... and (type_id='MM' or type_id='') 这意思？

[三石-gary]

应该写判断。。判断type_id是否为空。。
不为空：
SELECT EMP_CODE, EMP_NAME,time_beg,time_end,chk_days,chk_hour,type_id,remark
FROM dbo.mt_vacation,dbo.mt_personms
WHERE dbo.mt_vacation.empindex=dbo.mt_personms.empindex and EMP_CODE = 'MMColParam' and type_id='MM'
为空：
SELECT EMP_CODE, EMP_NAME,time_beg,time_end,chk_days,chk_hour,type_id,remark
FROM dbo.mt_vacation,dbo.mt_personms
WHERE dbo.mt_vacation.empindex=dbo.mt_personms.empindex and EMP_CODE = 'MMColParam'

[@信心]

sql="SELECT EMP_CODE, EMP_NAME,time_beg,time_end,chk_days,chk_hour,type_id,remark
FROM dbo.mt_vacation,dbo.mt_personms
WHERE dbo.mt_vacation.empindex=dbo.mt_personms.empindex and EMP_CODE = 'MMColParam'"

if(typeid="")
{sql=sql;}
else
{sql+=" and type_id='MM'" ;}

[LittleMo_2012]

Dim StrSql,StrWhere,s_type_id
s_type_id =传入值
StrWhere =""
StrSql="SELECT EMP_CODE, EMP_NAME,time_beg,time_end,chk_days,chk_hour,type_id,remark
FROM dbo.mt_vacation,dbo.mt_personms
WHERE dbo.mt_vacation.empindex=dbo.mt_personms.empindex and EMP_CODE = 'MMColParam'"

If not s_type_id="" Then
    
StrWhere=" and type_id="&s_type_id&""
End IF

StrSql =StrSql+StrWhere