Re: Display row with no value in column

I'm not sure I understand this question. Are you trying to print rows where total_time is null? SELECT oid,* FROM timeclock WHERE total_time IS NULL ORDER BY l_name

Comment on Re: Display row with no value in column Download Code

Replies are listed 'Best First'.
Re: Re: Display row with no value in column by earthboundmisfit (Chaplain) on Jul 20, 2001 at 21:55 UTC
A lot depends on the RDMS or ODBC driver (if using a flat file). IS NULL works with MySQL if the date field is set to not null but if it isn't, you have to use `.... WHERE total_time = '' ...` [download]	[reply] [d/l]
Re: Re: Display row with no value in column by nlafferty (Scribe) on Jul 20, 2001 at 22:00 UTC
total_time = NULL. that works terrific. Thanks. I just didn't really know how to specify the correct value for an empty field	[reply]