CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge -> General/Other

 Help with null values

Print topic Send  topic

Author Message
Juan
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
peterr


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 http://support.yessoftware.com
View profile  Send private message
Juan
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.

Thanks,

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 http://support.yessoftware.com.

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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