日期:2014-05-17  浏览次数:20905 次

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

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 "