asp搜索中有一个表单,定义date1和 date2
要搜索在这两个日期之间的表单数据
代码如下.<%
q1=trim(request("date1"))
q2=trim(request("date2"))if q1="" then
response.write "输入不能为空"
response.end
end ifset rst=server.createobject("adodb.recordset")
sql="select * from 4jinfo where jtime between "&q1&" and "&q2&""
rst.open sql,conn,1,1
%>搜索不到数据但如果把sql="select * from 4jinfo where jtime between "&q1&" and "&q2&""改为sql="select * from 4jinfo where jtime between "2000" and "2007""是可以使用的,能返回数值,麻烦请教问题出哪了
要搜索在这两个日期之间的表单数据
代码如下.<%
q1=trim(request("date1"))
q2=trim(request("date2"))if q1="" then
response.write "输入不能为空"
response.end
end ifset rst=server.createobject("adodb.recordset")
sql="select * from 4jinfo where jtime between "&q1&" and "&q2&""
rst.open sql,conn,1,1
%>搜索不到数据但如果把sql="select * from 4jinfo where jtime between "&q1&" and "&q2&""改为sql="select * from 4jinfo where jtime between "2000" and "2007""是可以使用的,能返回数值,麻烦请教问题出哪了
sql="select * from 4jinfo where jtime between '" & q1 &"' and '" & q2 &"'"access:
sql="select * from 4jinfo where jtime between #" & q1 &"# and #" & q2 &"#"
也就是说如果只填写年份date1=2000,date2=2007行吗
date1=y1+m1+d1
date2=y2+m2+d2select语句:
time1="'"&trim(Request.Form("y1"))&"-"&trim(Request.Form("m1"))&"-"&trim(Request.Form("d1"))&"'" time2="'"&trim(Request.Form("y2"))&"-"&trim(Request.Form("m2"))&"-"&trim(Request.Form("d2"))&"'"access:
sql="select * from 4jinfo where jtime between #" & time1 &"# and #" & time2 &"#"-----------------------------------
或者先定义变量
y1=trim(request("y1"))
m1=trim(request("m1"))
d1=trim(request("d1"))
y2=trim(request("y2"))
m2=trim(request("m2"))
d2=trim(request("d2"))
time1=y1-m1-d1
time2=y2-m2-d2
access:
sql="select * from 4jinfo where jtime between #" & time1 &"# and #" & time2 &"#"
我检查过了,知道哪错了,如果我填写搜索条件为date1=2000-01-01 date2=2007-12-31时候,是能够搜索的,如果少填写任何一位都是错的,是这样吗,有办法防止吗
也就是说如果只填写年份date1=2000,date2=2007行吗
------------------------
你是一個區間的話,最好在前台就控制好,必須輸入一個時間。如果用戶只輸入了年份,你可以自動給它加上一個月日.
y1=trim(request("y1"))
m1=trim(request("m1"))
d1=trim(request("d1"))
y2=trim(request("y2"))
m2=trim(request("m2"))
d2=trim(request("d2"))
time1=y1-m1-d1
time2=y2-m2-d2
access:
sql="select * from 4jinfo where jtime between #" & time1 &"# and #" & time2 &"#"
问题是我写的语句对吗?
sql="select * from 4jinfo where jtime between " & A &" and " & B &""
sql="select * from 4jinfo where jtime between " & A &" and " & B &""
--------這個是什麼意思?假設jtime類型是數值.sql="select * from 4jinfo where jtime between " & A &" and " & B
sql="select * from 4jinfo where jtime between " & A &" and " & B &""如果jtime类型为数值的话,对吗
也就是说如果只填写年份date1=2000,date2=2007行吗用if判断一下 如果是没有数值 给一个默认数值不就好了!2000-1-1