CodeCharge Studio
search Register Login  

Visual PHP Web Development

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 where clause to current date

Print topic Send  topic

Author Message
manuel

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
Lucius

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
manuel

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

Web Database

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.