CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> CodeCharge -> General/Other

 Help with null values

Print topic Send  topic

Author Message
Posted: 05/08/2004, 2:42 AM

I'm using CC. I want to be able to show all records base on a null value in the date field.

Is this done with SQL or Events?

Thanks, Juan

Posts: 5971
Posted: 05/08/2004, 12:28 PM

I didn't understand if you want to show all records that contain null dates, or all records if a null date is passed to the form (for example via the search)?
Peter R.
YesSoftware Forums Moderator
For product support please visit
View profile  Send private message
Posted: 05/08/2004, 1:26 PM

Hi Peter,

I found the answer by searching through the archives. I wanted to only to filter by a null date field.

I ended up using date_received IS NULL

The records are now filtering the way I want.


Juan :-)

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Internet Database

Visually create Web enabled database applications in minutes.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.