--C#的没问题吧.就看这句sql先定义两个参数: string v_country,string v_province
if (v_country.trim().tostring()=="")
{
:COUNTRY="COUNTRY";
}
else
{
:COUNTRY=v_country;
}if (v_province.trim().tostring()=="")
{
:PROVINCE="PROVINCE";
}
else
{
:PROVINCE=v_province;
}SELECT CITY FROM COM_ZIPCODE WHERE (COUNTRY = :COUNTRY) AND (PROVINCE= :PROVINCE) GROUP BY CITY ORDER BY CITY如果这时候输入的v_country为空的时候,那句sql就变成了SELECT CITY FROM COM_ZIPCODE WHERE (COUNTRY = COUNTRY) AND (PROVINCE= :PROVINCE) GROUP BY CITY ORDER BY CITY这样就可以不用country这个参数了.
if (v_country.trim().tostring()=="")
{
:COUNTRY="COUNTRY";
}
else
{
:COUNTRY=v_country;
}if (v_province.trim().tostring()=="")
{
:PROVINCE="PROVINCE";
}
else
{
:PROVINCE=v_province;
}SELECT CITY FROM COM_ZIPCODE WHERE (COUNTRY = :COUNTRY) AND (PROVINCE= :PROVINCE) GROUP BY CITY ORDER BY CITY如果这时候输入的v_country为空的时候,那句sql就变成了SELECT CITY FROM COM_ZIPCODE WHERE (COUNTRY = COUNTRY) AND (PROVINCE= :PROVINCE) GROUP BY CITY ORDER BY CITY这样就可以不用country这个参数了.
解决方案 »
- 求一条SQL
- 怎么同步两个用户的库表结构?
- 简单的SQL 请大家帮忙下~ 老师的作业
- asp.net datagrid 如何让数据项合并显示
- 用VB调用编译成功的存储过程时,出提示:第1行 第7列 必须说明标志符... 请教何故? 急!!!
- 使用sqlplus pool导出表里数据生成txt文件
- rollback
- 急救!!!Oracle8 执行Exp出错,出错信息为:EXP-0002,导出文件时出错,如何解决?
- 导入导出问题,提示权限不够
- 能将已有的表改为分区表吗?
- 关于数据库的查询
- 调用存储过程出错现象:在存储过程中使用not in ()方式引用传入字符型值时总是出错。vFCode参数的值应具备什么要求。
还是不行啊!当我用下面的语句时出错。
sqlSelectCity.Parameters(":PROVINCE").Value = ""
r = sqlSelectCity.ExecuteReader '这一行出错
"Parameter ':PROVINCE': No size set for variable length data type: String."
空值也能查了
SELECT CITY FROM COM_ZIPCODE WHERE (COUNTRY = :COUNTRY) AND (DECODE(PROVINCE,NULL,"",PROVINCE) = :PROVINCE) GROUP BY CITY ORDER BY CITY
语法错误:ORA-01741 illegal zero-length identifier我再试试:
SELECT CITY FROM COM_ZIPCODE WHERE (COUNTRY = :COUNTRY) AND (DECODE(PROVINCE,NULL," ",PROVINCE) = :PROVINCE) GROUP BY CITY ORDER BY CITY
语法错误:ORA-00904: " ": invalid identifier
死脑筋