CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> Archive -> GotoCode Archive

 greater than or equal (>=) not working in CCS 2.0

Print topic Send  topic

Author Message
rbell
Posted: 12/12/2003, 5:09 AM

When I try and get back all results greater than or equal to today date, it doesn't bring back today’s date but it will bring back all the other dates.

However when I try and do the reverse and use less than or equal to it works fine and brings back today’s date

Any ideas??

Thanks.
Ray.
Nicole
Posted: 12/15/2003, 6:06 AM

Ray,
What database you’re using?
I believe that it’d be easier to find out what’s wrong if you print the generated query and test it against the database. May be he problem is in specific data stored in the table.

I’m not sure what programming language you’re using so I do not provide the sample code that prints the query, you can check the code in the CCS help. Use Before Build Select event and print both SQL and WHERE.

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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