mysql查询报错_mysql查询报错，请高手帮帮忙

selectgsm.gsm_idasgsm_id,gsm.gsm_name,gsm.gsm_type,gsmalert.gsm_id,gsmalert.gsm_ad0type,gsmalert.gsm_ad0,gsmalert.gsm_ad1type,gsmalert.gsm_ad1,gsmalert.gsm_ad2type,gsmale...

select gsm.gsm_id as gsm_id,gsm.gsm_name,gsm.gsm_type,gsmalert.gsm_id,gsmalert.gsm_ad0type,

gsmalert.gsm_ad0,gsmalert.gsm_ad1type,gsmalert.gsm_ad1,gsmalert.gsm_ad2type,gsmalert.gsm_ad2,gsmalert.gsm_ad3type,gsmalert.gsm_ad3,

gsmalert.gsm_ad4type,gsmalert.gsm_ad4,gsmalert.gsm_ad5type,gsmalert.gsm_ad5,gsmalert.gsm_ad6type,gsmalert.gsm_ad6,

gsmalert.gsm_ad7type,gsmalert.gsm_ad7,gsmalert.gsm_ad8type,gsmalert.gsm_ad8,gsmalert.uploadtime from gsmalertinfo gsmalert,gsminfo gsm

where gsm.gsm_id=gsmalert.gsm_id and gsmalert.gsm_id='005' and gsmalert.uploadtime>='2011-04-24 16:24:56' and gsmalert.uploadtime<='2011-4-26 16:24:56'这句有错吗，在我本机运行正常，发布到iis上报错 提示：已有打开的与此连接相关联的 DataReader,必须首先将它关闭，我的链接方法中没有用到DataReader对象，MySqlConnection也Close了，我后来把时间条件去掉就可以了，不知道什么原因

我刚刚试了用一个时间条件可以，用两个就不行了

展开