Data not returned on Multible SQL Query

[Jorgen Hoffmeister]

Hi,

I have a Problem with the new .net Connecter ver. 1.0.2.

When I'm making an Query with multible SQL queries in one query like this.

SELECT viewhour.hourtext as 'Date Time', ifnull(count(dstport),0) AS 'Connections' FROM SrcDstStats right outer join viewhour ON hour(from_unixtime(timecollected)) = viewhour.hour and timecollected between 1099609200 and 1099695600 and dstport = 80 and devicetype = 0 GROUP BY viewhour.hour, viewhour.hourtext ORDER BY viewhour.hour asc;

SELECT viewhour.hourtext as 'Date Time', ifnull(count(dstport),0) AS 'Connections' FROM SrcDstStats right outer join viewhour ON hour(from_unixtime(timecollected)) = viewhour.hour and timecollected between 1099609200 and 1099695600 and dstport = 25 and devicetype = 0 GROUP BY viewhour.hour, viewhour.hourtext ORDER BY viewhour.hour asc;

Then it fails. Returns no data. But if its only one query then it returns data.

I'm using the dataadaptor to retrieve the data. It was working with the old ByteFX 0.76 version.

regards

Jorgen Hoffmeister