Re: Table Error?
From: cshenk <cshenk1_at_cox.net>
Date: Fri, 5 Jun 2009 17:08:32 -0400
Message-ID: <KJfWl.4218$IP7.1502_at_newsfe23.iad>
<art_at_unsu.com> wrote
Date: Fri, 5 Jun 2009 17:08:32 -0400
Message-ID: <KJfWl.4218$IP7.1502_at_newsfe23.iad>
<art_at_unsu.com> wrote
> This is really weird. We do a count on a table and get 5,954,235
> records. However, when we select the ata, there is only 1 record in
> the table????
>
> Suggestions anyone?
Offhand you are either accidently mixing table names and asking for fields that don't exist, or have a bad 'where' porton (such as other person said 'where field = null' doesnt work. where field = 'null' might if you have any where null is actually entered in there as the text!) Received on Fri Jun 05 2009 - 16:08:32 CDT