Go语言视频零基础入门到精通

搜搜风飒

Microsoft JET Database Engine 错误 '80040e14'  
內存溢出  

/so.asp，行 43  2

代码Ru下：
if diqu<>"" then
sql = "select * from xinxi where yz=1 and diqu like '%"&diqu&"%' and (leixing like '%"&key&"%' or biaoti like '%"&key&"%' or memo like '%"&key&"%' or com like '%1"&key&"%' or username like '%"&key&"%' or name like '%"&key&"%') order by b desc,id desc"
elseif cla1<>0 then
sql = "select * from xinxi where yz=1 and class1="&cla1&" and (leixing like '%"&key&"%' or biaoti like '%"&key&"%' or memo like '%"&key&"%' or diqu like '%"&key&"%' or com like '%"&key&"%' or username like '%"&key&"%' or name like '%"&key&"%') order by b desc,id desc"
elseif cla1=0 then
sql = "select * from xinxi where yz=1 and (leixing like '%"&key&"%' or biaoti like '%"&key&"%' or memo like '%"&key&"%' or diqu like '1%"&key&"%' or com like '%"&key&"%' or username like '%"&key&"%' or name like '%"&key&"%') order by b desc,id desc"
else
sql = "select * from xinxi where yz=1 and (leixing like '%"&key&"%' or biaoti like '%"&key&"%' or memo like '%"&key&"%' or diqu like '%"&key&"%' or com like '%"&key&"%' or username like '%"&key&"%' or name like '%"&key&"%') order by b desc,id desc"
end if
rs.open sql,conn,3,2 这li是43行
Pagesize=rs.Pagesize
Allrecord=rs.Recordcount
Allpage=rs.Pagecount
if ThisPage<1 then   
ThisPage=1   
end if
欢迎来到Java学xiZhe論坛,转载qing注明地址:http://www.javaxxz.com.

痴迷编程

把這三句分别拷到ACCESS的查询设计器里以SQL方式运行下试试.

可可西西

加上这两句，然后貼出实现的SQL语句内容是什么，应该是语法有错误。

response.write sql
response.end

rs.open sql,conn,3,2 這里是43行
Pagesize=rs.Pagesize

jspfan

将SQL语句显示出来看看，将字段名加[]试试

jjuiwe

添加两句后出现：

select * from xinxi where yz=1 and (leixing like '%房产%' or biaoti like '%房产%' or memo like '%房产%' or diqu like '%房產%' or com like '%房产%' or username like '%房产%' or name like '%房产%') order by b desc,id desc

jjuiwe

将字段名加[]
memo like '%房产%'->[memo] like '%房产%'
其它的自己写

彩虹糖梦

memo是保留字，加上[]

jjuiwe

memo是保留字，加上[]后显示如下

select * from xinxi where yz=1 and (leixing like '%教程%' or biaoti like '%教程%' or [memo] like '%教程%' or diqu like '%教程%' or com like '%教程%' or username like '%教程%' or name like '%教程%') order by b desc,id desc

叁点水

听说好像是字符集有问题，但我不太明白？

wujia

select * from xinxi where yz=1 and (leixing like '%教程%' or biaoti like '%教程%' or [memo] like '%教程%' or diqu like '%教程%' or [com] like '%教程%' or [username] like '%教程%' or [name] like '%教程%') order by b desc,[id] desc