cakephp: how to make NOW() work in search condition ?

Posted by kaklon on Stack Overflow See other posts from Stack Overflow or by kaklon
Published on 2010-04-20T21:21:56Z Indexed on 2010/04/21 1:53 UTC
Read the original article Hit count: 213

Filed under:

cakephp

|

mysql-query

I'm trying to get all records with date greater then now. I tried this but it doeasnt work:

$all_dates = $this->TourDate->find('all', array('conditions' => array('TourDate.date >=' => 'NOW()'), 'order' => array('TourDate.date ASC')));

If I replace NOW() with the current date it works. Why's that?

© Stack Overflow or respective owner

Related posts about cakephp

Losing sessions with window.open and cakephp redirection in PHP with cakephp

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys, Ok, here goes a very strange problem... Our team is using cakephp to develop a large application. Everything session related is working properly so far. The only issues we've had so far are related to iframes and opening windows in other subdomains. I'll explain: User opens up site… >>> More
CakePHP sending multiple lines of same cookie information in response header. why??

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I am having this problem with one of my cakePHP applications. My application displays a big html table on the page. I noticed that when the table goes beyond a certain size limit, IE cannot display that page. While trying to figure out why this happens, I noticed that my html response… >>> More
CakePHP: trouble configuring .htaccess for user directories enabled server

as seen on Server Fault - Search for 'Server Fault'
I've placed the CakePHP files in a directory in /home/user/public_html/cakephp. When I try to reach localhost/~user/cakephp with my browser, there's an error message. In my case, since I'm using Chrome, it is 'Oops! This link appears to be broken.". Looking for a solution on Google, I found a few… >>> More
CakePHP: 2-level JOIN with one Query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following models in CakePHP: A Deposit belongs to an Account An Account belongs to a Customer I want to have a list of Deposits, and I need to show the name of the customer (so I have to join through the Customer). I also need to paginate this list. If I set Deposit->recursive = 2… >>> More
[CakePHP] Can not Bake table model, controller and view

as seen on Stack Overflow - Search for 'Stack Overflow'
I developed small CakePHP application, and now I want to add one more table (in fact, model/controller/view) into system, named notes. I had already created a table of course. But when I run command cake bake model, I do not get table Notes on the list. I can add it manually, but after that I get… >>> More

Related posts about mysql-query

MySQL query returns different set of results on two identical databases

as seen on Stack Overflow - Search for 'Stack Overflow'
I exported a live MySQL database (running mysql 5.0.45) to a local copy (running mysql 5.1.33) with no errors upon import. There is a view in the database, that when executed locally, returns a different set of data than when executed remotely. It's returning 32 results instead of 63. When I execute… >>> More
What's wrong with my MySql query ?!

as seen on Stack Overflow - Search for 'Stack Overflow'
This is a query I am doing with mysql using PHP This is the query line <?php $query = "SELECT * FROM node WHERE type = 'student_report' AND uid = '{$uid}' LIMIT 1 ORDER BY created DESC"; ?> I get the following error You have an error in your SQL syntax; check the manual that corresponds… >>> More
Optimizing the MySQL Query Cache

as seen on Internet.com - Search for 'Internet.com'
MySQL's query cache is an impressive piece of engineering if sometimes misunderstood. Keeping it optimized and used efficiently can make a big difference in the overall throughput of your application, so it's worth taking a look under the hood, understanding it, and then keeping it tuned optimally. >>> More
mysql query using jdbc

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I have the following table: Service_ID feedback 31 1 32 1 33 1 1 I have the sample code to find the sum: ResultSet res = st.executeQuery("SELECT Service_ID,SUM(consumer_feedback)… >>> More
index help for a MySQL query using greater-than operator and ORDER BY

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a table with at least a couple million rows and a schema of all integers that looks roughly like this: start stop first_user_id second_user_id The rows get pulled using the following queries: SELECT * FROM tbl_name WHERE stop >= M AND first_user_id=N AND second_user_id=N… >>> More