Re: How to use CURRENT_TIMESTAMP in find conditions array

2010-09-20 Thread Andy Dirnberger
Did you try array(..., 'ClubsPlayer.start_datetime = CURRENT_TIMESTAMP')? On Sep 19, 5:38 pm, DerBjörn b.unkh...@googlemail.com wrote: Hi Zaky, yes with time() it works like that: ClubsPlayer.start_datetime =' = date('Y-m-d H:i:s', time()) but i thought there is a easilier way :) Thanks

How to use CURRENT_TIMESTAMP in find conditions array

2010-09-19 Thread DerBjörn
Hi, when i use something like $paginate = array('ClubsPlayer.club_id ' = $club_id, 'ClubsPlayer.start_datetime =' = 'CURRENT_TIMESTAMP'); Then the CURRENT_TIMESTAMP will be in quotes in my query: `ClubsPlayer`.`start_datetime` = 'CURRENT_TIMESTAMP' How to use it correctly? THANKS :) Check out

Re: How to use CURRENT_TIMESTAMP in find conditions array

2010-09-19 Thread j.blotus
try outting it into your conditions without quotes since it is a constant On Sep 19, 11:21 am, DerBjörn b.unkh...@googlemail.com wrote: Hi, when i use something like $paginate = array('ClubsPlayer.club_id ' = $club_id, 'ClubsPlayer.start_datetime =' = 'CURRENT_TIMESTAMP'); Then the

Re: How to use CURRENT_TIMESTAMP in find conditions array

2010-09-19 Thread DerBjörn
Thanks for your response, unfortunately ...'ClubsPlayer.start_datetime =' = CURRENT_TIMESTAMP); has the same effect... a quoted 'CURRENT_TIMESTAMP' in the quey :( On 19 Sep., 13:17, j.blotus j.blo...@gmail.com wrote: try outting it into your conditions without quotes since it is a constant On

Re: How to use CURRENT_TIMESTAMP in find conditions array

2010-09-19 Thread Zaky Katalan-Ezra
Use php time() function as a parameter or create a custom query. Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send

Re: How to use CURRENT_TIMESTAMP in find conditions array

2010-09-19 Thread DerBjörn
Hi Zaky, yes with time() it works like that: ClubsPlayer.start_datetime =' = date('Y-m-d H:i:s', time()) but i thought there is a easilier way :) Thanks anyway! Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this