Mysqld = New SqlDataAdapter("SELECT * FROM customer WHERE(time > '"& Convert.toDateTime(Request.QueryString("condition1")) & "' and time < '" & Convert.toDateTime(Request.QueryString("condition2")) & "') order By id desc",Mysql) 收索不到复合条件的数据,但是我换成SELECT *
FROM customer
WHERE ([time] > '2004-11-21') AND ([time] < '2004-12-30')
ORDER BY id DESC 大家看看是不是我第一个语句有问题。谢谢
FROM customer
WHERE ([time] > '2004-11-21') AND ([time] < '2004-12-30')
ORDER BY id DESC 大家看看是不是我第一个语句有问题。谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货