SQL 查询语句--帮新手一把 万分感谢

来源:百度知道 编辑:UC知道 时间:2024/06/24 15:27:56
<tr><td>请输入时间段</td><td><input type="text" name="turn1" size="10">至<input type="text" name="turn2" size="10"></td>
<td><input type="submit" value="确定"></td>
</tr>
<%
if Trim(Request("turn1"))<>"" and Trim(Request("turn2"))<>"" Then
Dim rs,strSql
Set rs=Server.CreateObject("ADODB.Recordset")
strSql="Select * From users Where turn between #" & Trim(Request("turn1")) & "# and #" & Trim(Request("turn2")) & "#"
rs.Open strSql,conn,1
If rs.RecordCount<=0 Then
Response.Write "对不起,没有你查询的信息"
Else
Response.Write "共有" & rs.RecordCount & "条记录"
%>
为什么这样写不行?

<tr><td>请输入时间段</td><td><input type="text" name="turn1" size="10">至<input type="text" name="turn2" size="10"></td>
<td><input type="submit" value="确定"></td>
</tr>
<%
if Trim(Request("turn1"))<>"" and Trim(Request("turn2"))<>"" Then
Dim rs,strSql
Set rs=Server.CreateObject("ADODB.Recordset")
strSql="Select * From users Where turn between '" & Trim(Request("turn1")) & "' and '" & Trim(Request("turn2")) & "'"
rs.Open strSql,conn,1
If rs.RecordCount<=0 Then
Response.Write "对不起,没有你查询的信息"
Else
Response.Write "共有" & rs.RecordCount & "条记录"
%>