elson12

Members
 View Profile  See their activity

  • Content count

    4

  • Joined

  • Last visited

About elson12

  • Rank
    Forum Newbie

  1. System.Byte[]

    elson12 posted a topic in FusionCharts and ASP.NET

    i got select an qry : "select distinct monthname(RDate) as monthname,mid(RDate,1,4) as year,sum(case when Type = 'Got No R' then 1 else 0 end) as NoR,sum(case when Type = 'Got R' then 1 else 0 end) as GOTR from sample where RDate between '" & a & "-" & c & "-%' and '" & b & "-" & d & "-% ' group by monthname,year order by year,monthname;"then, my categories will be monthname&year such as March2008 but, my output was System.Byte[]. why ? in the database, RDate datatype is date. got any solution ? thanks