"rob" <ro*@pleaseremovespamcherny.com> wrote in message
news:XY********************@giganews.com...
Hey,
I've got an Classic ASP app pulling some records out of a DB, which
worked fine when it was Access. When we upped to SQL Server, all of a
sudden, when the Recordsets came back, all the dates were empty, even
though the data was showing up in the DB.
About a year ago (only code asp apps once and a while), I remember
seeing this and finding something that just had something to do with the
order in which something was being referenced, but I just can't for the
life of me remember what it was.
The Dates are set as datetime, length of 8.
Anyone know why this happens and a solution?
many thanks,
rob
It's not really possible to give a good answer without more information. Do
you have an example of a query which returns data in Query Analyzer, but not
in ASP?
You might also look at
www.aspfaq.com, if you haven't already - there are
quite a lot of articles about handling dates.
Simon