inputdate为日期型,数据库里明明有满足条件的数据但就是查不到~~~
sql = "select * from todaywork where nid="&id&" and inputdate="&request("mydate")
sql = "select * from todaywork where nid="&id&" and inputdate="&request("mydate")有问题啊,如果是SQL数据库:sql = "select * from todaywork where nid="&id&" and inputdate=" & request("mydate") & ""
如果是ACCESS:sql = "select * from todaywork where nid="&id&" and inputdate=#" & request("mydate") & "#"
还有,要检查你的nid字段,如果是字符型的,也要加号:nid=" & id & "但如果是数字型就不必了,书写要规范,注意该使用空格的地方一定不要省