Uid Uname daytime cardtime superDay goodDay normalDay badDay62266666 123 2009-8-22 10:12:52 542180438 274 8995 288 21008
62266666 123 2009-8-23 10:13:13 542180438 274 8995 288 21008
62266666 123 2009-9-9 10:15:11 542180438 274 8995 288 21008
62288888 未命名 2009-8-22 10:12:52 0 4608 22016 32768 7
62288888 未命名 2009-9-9 10:15:11 0 4608 22016 32768 7有这个样的一个表 我写的select 查询语句
sqlstr = "select sum(superDay) As superDay,sum(goodDay) As goodDay,sum(normalDay) As normalDay,sum(badDay) As badDay from DayReport group by daytime like '%" & tyear & "-" & i & "%' and Uid='" & uid & "'"
tyear 是可以选择年的,i是选择月的
要是选择的月或者年在数据库中没有的话 怎么也能查询出来数据库?这个是为什么?例如:tyear =2009 i= 7,8,9 这个是循环查询的id name super good normal bad 月份
62266666 123 274 8995 288 21008 2009-9
62266666 123 548 17990 576 42016 2009-8
62266666 123 14646 93033 99168 63045 2009-7
这个问题怎么解决 请教高人
62266666 123 2009-8-23 10:13:13 542180438 274 8995 288 21008
62266666 123 2009-9-9 10:15:11 542180438 274 8995 288 21008
62288888 未命名 2009-8-22 10:12:52 0 4608 22016 32768 7
62288888 未命名 2009-9-9 10:15:11 0 4608 22016 32768 7有这个样的一个表 我写的select 查询语句
sqlstr = "select sum(superDay) As superDay,sum(goodDay) As goodDay,sum(normalDay) As normalDay,sum(badDay) As badDay from DayReport group by daytime like '%" & tyear & "-" & i & "%' and Uid='" & uid & "'"
tyear 是可以选择年的,i是选择月的
要是选择的月或者年在数据库中没有的话 怎么也能查询出来数据库?这个是为什么?例如:tyear =2009 i= 7,8,9 这个是循环查询的id name super good normal bad 月份
62266666 123 274 8995 288 21008 2009-9
62266666 123 548 17990 576 42016 2009-8
62266666 123 14646 93033 99168 63045 2009-7
这个问题怎么解决 请教高人
sqlstr = "select sum(superDay) As superDay,sum(goodDay) As goodDay,sum(normalDay) As normalDay,sum(badDay) As badDay from DayReport where year(daytime)="& tyear &" and month(daytime) in ("& i &") and Uid='" & uid & "'"