提示:至少一个参数没有被指定值。错误!!
我做一个条件查询,但是提示代码错误:源码为:
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 "