读书人

提示:至少一个参数没有被指定值。异常

发布时间: 2012-02-08 19:52:21 作者: rapoo

提示:至少一个参数没有被指定值。错误!!
我做一个条件查询,但是提示代码错误:源码为:

keytime=clng(request( "keytime "))
Response.Write(keytime)
If keytime <> " " Then
sql= "select * from love where DateDiff( 'h ',now,love_time) <keytime order by love_time asc "
Else
sql= "select * from love order by love_time asc "
End If

我通过Response.Write(keytime)看到确实有值,但是老提示错误!!

[解决办法]
sql= "select * from love where DateDiff( 'h ',now,love_time) < " & keytime & " order by love_time asc "

读书人网 >ASP

热点推荐