日期查询问题MicrosoftJETDatabaseEngine错误80040e14语法错误(操作符丢失)在查询表达式wherefa_databetwe
日期查询问题
Microsoft JET Database Engine 错误 '80040e14 '
语法错误 (操作符丢失) 在查询表达式 'where fa_data between #2007-4-1# and fa_data <=#2007-5-31# ' 中。
starttime= "2007-4-1 "
endtime= "2007-5-31 "
set rs=server.createobject( "adodb.recordset ")
rs.open "select * from fa where where fa_data between # "&starttime& "# and fa_data <=# "&endtime& "# ",db,1,3
[解决办法]
rs.open "select * from fa where where fa_data between ' "&starttime& " ' and fa_data <= ' "&endtime& " ' ",db,1,3
你查询付值的时候不是直接是时间就不用#