Submit My Question - Recent Questions - Recent Answer

急,sql查询问题

用ASP写了个下拉列表
<select name="result">
<option value=""></option>
<option value="xs">aa</option>
</select>
后用SQL进行查询
select * from db where cjjg="&result&" or "&result&" is null
为何只要加上判断"&result&" is null就无法查询出结果?
请各位帮忙看看,谢谢.

[305 byte] By [clarechao-clare] at [2008-1-9]

«« 索引导致插入速度急剧下降的问题
»» 项目外包,寻求技术高手合作

# 1

select * from db where cjjg="&result&" or cjjg is null or cjjg = ''

dawugui-潇洒老乌龟 at 2007-10-18 >