1 select * from A1 where B1 like 'm'2 select * from A1 where B1 like 'n' and 'o'前提是必须先根据1筛选,再从1筛选得结果里进行2筛选,否则就会出错,请问应该怎麽写?
解决方案 »
- 数据库,事务回滚
- Response.StatusCode = 404;页面加入后,在IE中打不开
- GridView的奇怪问题,GridView的数据源是抽象类的集合,集合中添加不同抽象类的实现会抛出异常,同一个实现不会抛出异常。
- .net的gridview+dropdownlist问题
- 单选控件radiobutton的属性问题!简单。着急!
- 怎样设置<A href....> 使得点击ASP.NET的Button时,能够使页面跳转到特殊的位置
- 编译时出现这个错误:读取密钥文件“..\..\myKeyPair.snk”时出错,如何解决?
- 在IIS5.1中怎样使用ASP.NET 呀?
- 这么写存储过程会不会很慢,,,,??
- 为何ASP与ASP.NET无法共享Session中的变量?
- 关于VS.NET编辑器
- 请repeater或者DataGrid三层嵌套怎么做?
本身就是错误的
这样应该也行
select * from A1 where B1 like '%n%' and B1 like '%o%' and B1 like '%m%'
也不行啊,
只执行了B1 in (select B1 from A1 where B1 like '%m%'),
而 B1 like '%n%' and B1 like '%o%'没有执行
tsql=tsql+" guige in(select guige from ziyuan where guige like '%*%*%') "
tsql=tsql+" and left(guige,instr(guige,'*')-1) between "+strzyggh1+" and "+strzyggh2+""
tsql=tsql+" and Mid(guige,InStr(guige,'*')+1 ,InStr(InStr(guige,'*')+1,guige,'*')-InStr(guige,'*')-1) "
tsql=tsql+" between "+strzyggk1+" and "+strzyggk2+"" tsql=tsql+" order by shijian DESC"测试后提示:System.Data.OleDb.OleDbException: 无效的过程调用
dim tSQL as string = "select * from ziyuan where " 这句是vb.net的
而tsql=tsql+" guige in(select guige from ziyuan where guige like '%*%*%') "里面的+又表明是c#把+都换成&
tsql=tsql & " guige in(select guige from ziyuan where guige like '%*%*%') " tsql=tsql & " and left(guige,instr(guige,'*')-1) between "& strzyggh1 & " and " & strzyggh2 & ""
tsql=tsql &" and Mid(guige,InStr(guige,'*')+1 ,InStr(InStr(guige,'*')+1,guige,'*')-InStr(guige,'*')-1) "
tsql=tsql & " between " & strzyggk1 &" and " & strzyggk2 &"" tsql=tsql & " order by shijian DESC"
test
select mytable.A
from mytable,mytable as T1,mytable as T2,mytable as T3
where
mytable.ID=T1.ID and T1.ID=T2.ID and T2.ID=T3.ID and
mytable.B in (select B from T1 where B like '%m%' ) and
mytable.B in (select B from T2 where B like '%n%' ) and
mytable.B in (select B from T3 where B like '%o%' )
我用了个笨办法,如果为负值就用个OR 来个无厘头得条件,结果发现通过测试了
谢谢各位啦