string strSql = "(select t.id,t.coursename,t.image,tt.tagword from dlcourse t,dlcoursetag tt on t.id = tt.courseid where ((t.id like '%" + searchWord + "%') or (t.coursename like '%" + searchWord + "%') or (t.content like '%" + searchWord + "%') or (t.catogery like '%" + searchWord + "%') or (t.coursedesc like '%" + searchWord + "%') or (t.kechengtedian like '%" + searchWord + "%') or (tt.tagword like '%" + searchWord + "%')))";
写的一段数据库搜索代码,在Visual Studio中总是提示 缺少右括号。但是我检查了括号是匹配的啊!
或者 哪位给我说一下 怎么做网站的搜索啊? 给个思路就可以了Error in LoadDataSetfromSql method. SQL is: (select t.id,t.coursename,t.image,tt.tagword from dlcourse t,dlcoursetag tt on t.id = tt.courseid where ((t.id like '%对话%') or (t.coursename like '%对话%') or (t.content like '%对话%') or (t.catogery like '%对话%') or (t.coursedesc like '%对话%') or (t.kechengtedian like '%对话%') or (tt.tagword like '%对话%')))ORA-00907: 缺少右括号Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Exception: Error in LoadDataSetfromSql method. SQL is: (select t.id,t.coursename,t.image,tt.tagword from dlcourse t,dlcoursetag tt on t.id = tt.courseid where ((t.id like '%对话%') or (t.coursename like '%对话%') or (t.content like '%对话%') or (t.catogery like '%对话%') or (t.coursedesc like '%对话%') or (t.kechengtedian like '%对话%') or (tt.tagword like '%对话%')))ORA-00907: 缺少右括号
解决方案 »
- 三表Full Join,求SQL优化。
- oracle 获取表名,并对变量表名进行查询
- 索引新建后,是否对正运行中的存储过程生效
- 数据转移sqlserver->oracle
- 怎麼才能讓null和一個日期進行比較??
- 启动不了"ManagementServer"服务,提示I/O正在操作中.
- 是否可以同一个job调用多个过程
- ELPHI开发中能否将JPEG图片保存到ORACLE的LONG RAW数据表字段里,如何存取?
- 怎么找到oo4ocodewiz.exe???--急
- Oracle如何根据条件关联查询另一个表计数数据
- 疑难杂症,太抑郁了,请各位高手帮帮手
- ORACLE 远程连接的问题,急!!在线等
-->
select t.id,t.coursename,t.image,tt.tagword from dlcourse t,dlcoursetag tt where t.id = tt.courseid and
string strSql = "(select t.id,t.coursename,t.image,tt.tagword from dlcourse t join dlcoursetag tt on t.id = tt.courseid where ((t.id like '%" + searchWord + "%') or (t.coursename like '%" + searchWord + "%') or (t.content like '%" + searchWord + "%') or (t.catogery like '%" + searchWord + "%') or (t.coursedesc like '%" + searchWord + "%') or (t.kechengtedian like '%" + searchWord + "%') or (tt.tagword like '%" + searchWord + "%')))";
string strSql = "(select t.id,t.coursename,t.image,tt.tagword from dlcourse t left join dlcoursetag tt on t.id = tt.courseid where ((t.id like '%" + searchWord + "%') or (t.coursename like '%" + searchWord + "%') or (t.content like '%" + searchWord + "%') or (t.catogery like '%" + searchWord + "%') or (t.coursedesc like '%" + searchWord + "%') or (t.kechengtedian like '%" + searchWord + "%') or (tt.tagword like '%" + searchWord + "%')))";string strSql = "(select t.id,t.coursename,t.image,tt.tagword from dlcourse t right join dlcoursetag tt on t.id = tt.courseid where ((t.id like '%" + searchWord + "%') or (t.coursename like '%" + searchWord + "%') or (t.content like '%" + searchWord + "%') or (t.catogery like '%" + searchWord + "%') or (t.coursedesc like '%" + searchWord + "%') or (t.kechengtedian like '%" + searchWord + "%') or (tt.tagword like '%" + searchWord + "%')))";string strSql = "(select t.id,t.coursename,t.image,tt.tagword from dlcourse t full join dlcoursetag tt on t.id = tt.courseid where ((t.id like '%" + searchWord + "%') or (t.coursename like '%" + searchWord + "%') or (t.content like '%" + searchWord + "%') or (t.catogery like '%" + searchWord + "%') or (t.coursedesc like '%" + searchWord + "%') or (t.kechengtedian like '%" + searchWord + "%') or (tt.tagword like '%" + searchWord + "%')))";
如果没有使用的话 那么要在where子句中指定