CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.

YesSoftware Forums -> CodeCharge Studio -> PHP

 where clause to current date

Print topic Send  topic

Author Message

Posts: 48
Posted: 06/04/2013, 8:23 PM

How can I filter the form data based on current date, I tried adding a WHERE clause to the "Data Source" with now(), CURDATE(), etc. but it sends an error.

There's a special clause in CCS for this? I cant do this in the DDBB (only read access)

using php+mysql
View profile  Send private message

Posts: 220
Posted: 06/05/2013, 8:29 AM

What is the full SQL constructed for the form, when you try to add some condition based on the date?
View profile  Send private message

Posts: 48
Posted: 06/05/2013, 2:23 PM

I used CCS query builder, choose only 1 table, a few fields, and two where clause's: 1 based on the url (worked fine) and the other based on the date (sends an error). I set both as "expression"

At the end, I changed the SQL statement directly in the .php page. I just have to remember to change it back every time I update the code in CCS.
View profile  Send private message

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

Web Database

Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

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