System.Byte[]

[elson12]

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

[Pallav]

Your scripting language might be doing any dynamic casting...