查询会员表,在选择会员类型时,可选择全部,男会员,女会员.
F_SEX='',全选
F_SEX='F',
F_SEX='M'
SELECT * FROM TB_MEMBER WHERE
B_COLUMN=F_B
and (f_sex is null or ( f_sex is not null and sex= f_sex ))
或是
and (nvl(f_sex,'')='' or (nvl( f_sex ,'')<>'' and sex= f_sex ))
以上两种情况,都不能查询出想要的数据.
就是因为F_A 值为空而出问题,找不到原因.
最后把F_A 初值设置为
F_sex='ALL',F_sex='F',F_SEX='M'
.修改如下:
and (f_a='all'or (f_a is not null and sex=f_a))
F_SEX='',全选
F_SEX='F',
F_SEX='M'
SELECT * FROM TB_MEMBER WHERE
B_COLUMN=F_B
and (f_sex is null or ( f_sex is not null and sex= f_sex ))
或是
and (nvl(f_sex,'')='' or (nvl( f_sex ,'')<>'' and sex= f_sex ))
以上两种情况,都不能查询出想要的数据.
就是因为F_A 值为空而出问题,找不到原因.
最后把F_A 初值设置为
F_sex='ALL',F_sex='F',F_SEX='M'
.修改如下:
and (f_a='all'or (f_a is not null and sex=f_a))