Re: Display records even if 800a0bcd

..NET framework assumes a null date as 1/1/1 while SQL Server 2000 sets it to
1/1/1900. So beware of nulls !
Post some code before we can think of a solution!

HTH
RAJESH MEENRAJAN
MCSD.NET
http://meenrajan.blogspot.com

"Bob Barrows [MVP]" wrote:

> Ale wrote:
> > Hello guys, I have a db
>
> What database? Type and version, please?
>
> > where into a table I have a field that
> > sometimes is empty (like consignment date).
> > During my SQL query if this field has data all other fields are
> > displayed o/w all fields are set to NULL and nothing is displayed and
> > I have to use the "On Error Resume Next".
> > Is there a way to avoid the 800a0bcd error and get results from all
> > other records, except the null one?
>
>
> Show us some code to reproduce this error please. We don't want to see any
> html, just the smallest amount of asp code that will allow us to see what
> your problem is.
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
>