GetRows returns blank fields when there's really data.

[JeremyG]

I have a SQL database with a table consisting of about 16 fields.

I create an ADODB recordset and execute my query with no errors. Then i do a GetRows() and it is loaded into an array. However for some reason the date fields and bit fields come up as blank in the array....and I can't figure out why.

To make things even stranger, if I read a particular date field from the record set then that field will load into the array properly.

-----------------------
This returns blank a blank field for MmyDate in the array:

RecordSet.Open "query", ConObj
MyArray = Recordset.getrows
-----------------------
This returns the MyDate field properly in the array

RecordSet.Open "query", ConObj
Response.write RecordSet("MyDate&quot
MyArray = Recordset.getrows
---------------------

ANY help would be much appreciated!