佬大帮帮忙了。小弟的那里编错了。请指点，最好能帮改好一下解决方案-ASP教程-爱易网页

佬大帮帮忙了。小弟的那里编错了。请指点，最好能帮改好一下解决方案

日期：2014-05-17　浏览次数：20954 次

佬大帮帮忙了。小弟的那里编错了。请指点，最好能帮改好一下



<%
if cint(session( "aleave "))=4 then
chk_pass( "ck2 ")
end if
%>
<%
page=clng(request.Querystring( "page "))
guize=request( "guize ")
seastr=request( "seastr ")

if guize= "one " then
fromend=now()
fromnow=dateadd( "d ",-1,now())

sql= "select * from model where infotime Between # "&fromnow& "# and # "&fromend& "# "
end if

if guize= "tow " then
fromend=now()
fromnow=dateadd( "d ",-3,now())

sql= "select * from model where infotime Between # "&fromnow& "# and # "&fromend& "# "
end if

if guize= "three " then
fromend=now()
fromnow=dateadd( "d ",-7,now())

sql= "select * from model where infotime Between # "&fromnow& "# and # "&fromend& "# "
end if

if guize= "allmol " or len(guize)=0 then
sql= "select * from model order by id desc "
end if

if guize= "mjiaju " then
sql= "select * from model where fenglei1 <> '灯具/照明 ' and fenglei1 <> '其它 ' order by id desc "
end if

if guize= "mdeng " then
sql= "select * from model where fenglei1= '灯具/照明 ' order by id desc "
end if

if guize= "mshipin " then
sql= "select * from model where fenglei1= '其它 ' order by id desc "
end if

if guize= "shencha " then
sql= "select * from model where shouye=false order by id desc "
end if

if len(seastr) <> 0 then
sql= "select * from model where model_name like '% " & seastr & "% ' order by id desc "
end if
dim rs
set rs=server.createobject( "adodb.recordset ")
rs.open sql,conn,1,1

%>
<Html>
<head>
<title> 模型文件管理 </title>
<link href= "../css.css " rel= "stylesheet " type= "text/css ">
<style type= "text/css ">

</style>
</head>
<body>
<br>
<center> 模型文件管理 </center>
<br>
<table

免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。

佬大帮帮忙了。小弟的那里编错了。请指点，最好能帮改好一下解决方案

相关资料更多>

推荐阅读更多>