我想查询根据用户选择查询一段时间内的数据.(可以选择当天,一星期内,一个月内,和所有数据),但我的sql语句这样写却总是查询不出来,请问应该怎么样写才正确.我把代码贴出来Function returnmydate() As DateTime
Dim mydate As DateTime
If rd_day.Checked = True Then mydate = System.DateTime.Now.AddDays(-1)
If rd_week.Checked = True Then mydate = System.DateTime.Now.AddDays(-8)
If Rd_month.Checked = True Then mydate = System.DateTime.Now.AddDays(-31)
If Rd_all.Checked = True Then mydate = System.DateTime.Now.AddDays(-60000)
Return mydate
End Functionviewstate("mysql") = "select * from fadj where lasj>'" + returnmydate() + "'" 谁能告诉我这错在那里啊,谢了
Dim mydate As DateTime
If rd_day.Checked = True Then mydate = System.DateTime.Now.AddDays(-1)
If rd_week.Checked = True Then mydate = System.DateTime.Now.AddDays(-8)
If Rd_month.Checked = True Then mydate = System.DateTime.Now.AddDays(-31)
If Rd_all.Checked = True Then mydate = System.DateTime.Now.AddDays(-60000)
Return mydate
End Functionviewstate("mysql") = "select * from fadj where lasj>'" + returnmydate() + "'" 谁能告诉我这错在那里啊,谢了
程序出错,信息描述如下:
标准表达式中数据类型不匹配。请问为什么会这样
也可能是我写三层写习惯了.