Adodc1.RecordSource = "select * from liulan where liulan1 between " + Str(DTPicker1.Value) + "and " + Str(DTPicker2.Value) + "order by liulan1"
Adodc1.Refresh
我是用DATAGRIDGN ADODC连接。目的是想通过两DTPicker日历控件年所显示的日期来查询满足条件的相关信息。
请问以上语句哪里有问题,总出现如下提示:
将VACHAR值'2006-3-6'转换成数据为数据类型为INT的列时发生语法错误。
请高手指教谢谢谢啊!
Adodc1.Refresh
我是用DATAGRIDGN ADODC连接。目的是想通过两DTPicker日历控件年所显示的日期来查询满足条件的相关信息。
请问以上语句哪里有问题,总出现如下提示:
将VACHAR值'2006-3-6'转换成数据为数据类型为INT的列时发生语法错误。
请高手指教谢谢谢啊!
加号中间少了个空格
"select * from liulan where liulan1 between # " & DTPicker1.Value & " # and # " & DTPicker2.Value & " # order by liulan1"
数据库为SQL:
"select * from liulan where liulan1 between '" & DTPicker1.Value & "' and '" & DTPicker2.Value & "' order by liulan1"
还想请教个问题,上面的SQL语句我试去可是结果集为空,满足条件的记录都没有显示啊。
"select * from liulan where liulan1 between '2006-5-14 00:00:01' and '2006-5-14 23:59:59' order by liulan1"