伊萨卡国际城哪一期好:FROM 子句语法错误

来源:百度文库 编辑:高考问答 时间:2024/05/05 03:35:56
错误类型:
Microsoft JET Database Engine (0x80040E14)
FROM 子句语法错误。
/user/manage/list_money.asp, 第 58 行

浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Maxthon)

网页:
POST 44 ??? /user/manage/list_money.asp

POST Data:
keyword=test&range=0

----------

<%

function object_selected(current_value,value)
if current_value=value then
sel_str="selected"
else
sel_str=""
end if
object_selected=sel_str
end function

if Request.ServerVariables("HTTP_METHOD")="POST" then '查询时

keyword=Request.Form("keyword") '开始相关链接的查询
range=Request.Form("range")

if range="" or not isnumeric(range) then
range=0
else
range=cint(range)
if range<0 or range>4 then range=0
end if

sqlstr="select * from t_money"

if keyword<>"" then
sqlstr=sqlstr & " and (money_info like '%" & keyword & "%')"
end if

select case range
case 0
sqlstr=sqlstr
case 1
sqlstr=sqlstr & "and DATEDIFF('d',[money_time],'"&now()&"')<1"
case 2
sqlstr=sqlstr & "and DATEDIFF('d',[money_time],'"&now()&"')<7"
case 3
sqlstr=sqlstr & "and DATEDIFF('d',[money_time],'"&now()&"')<15"
case 4
sqlstr=sqlstr & "and DATEDIFF('d',[money_time],'"&now()&"')<30"
case else
sqlstr=sqlstr
end select
sqlstr=sqlstr & " order by money_id asc"
else
sqlstr="select * from t_money order by money_id asc"
end if
%>
<%@language="VBscript"%>
<%Response.Expires=0%>
<!--#include file="../../admin/include/checkuser.asp" -->
<!--#include file="../../admin/include/db_conn_ii.asp" -->

----------
db_conn_ii.asp

<%
dim conn
dim connstr
dim db
db="../../admin/#71eq_o_.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
'如果你的服务器采用较老版本Access驱动,请用下面连接方法
'connstr="driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath(db)
conn.Open connstr
%>

该文件是从另外一个文件改写而来,用同数据库中不同的表的数据。很奇怪,调用正常,只是在搜索的时候提示这个地方错误

把and 改成where

实在找不出来哪里错了