Re: REgarding using Mysql functions like NOW(), CURDATE() etc

2008-11-29 Thread Rafael Bandeira aka rafaelbandeira3
> Finally if you are hopping that cake allow you to make mysql function calls > inside a query you should read thishttps://trac.cakephp.org/ticket/5345as > stateted that "it would actually > make SQL injection a *feature" > Notice that every user input should be properly sanitized and escaped if

Re: REgarding using Mysql functions like NOW(), CURDATE() etc

2008-11-29 Thread Federico Rinaldi
Sorry I just addressed your specific problem. As your cuestion about being able to call a mysql function, I think you are missing the point about cake's database abstraction layer so your application would become database dependant. If that is not an issue for you, try this link: http://rafaelband

Re: REgarding using Mysql functions like NOW(), CURDATE() etc

2008-11-29 Thread Malcolm Krugger
"On Nov 29, 9:42 pm, the_woodsman <[EMAIL PROTECTED]> wrote: > I don't think Federico has answered your general question about using > MySQL functions," Yes correct. and I would very much like to believe, that cakephp already has some method(s) to harness the power of the multitude of Mysql fu

Re: REgarding using Mysql functions like NOW(), CURDATE() etc

2008-11-29 Thread the_woodsman
I don't think Federico has answered your general question about using MySQL functions, and neither can I - but on the up side, I think that Federico's query will perform better than using CURDATE() ;) On Nov 29, 4:20 pm, "Federico Rinaldi" <[EMAIL PROTECTED]> wrote: > Have you tried with: > > $th

Re: REgarding using Mysql functions like NOW(), CURDATE() etc

2008-11-29 Thread Federico Rinaldi
Have you tried with: $this->data['User']['signedup'] = date("Y-m-d"); FedeX On Sat, Nov 29, 2008 at 12:23 PM, Malcolm Krugger < [EMAIL PROTECTED]> wrote: > > I maybe missing the obvious, But can someone please point the right > syntax for > >$this

REgarding using Mysql functions like NOW(), CURDATE() etc

2008-11-29 Thread Malcolm Krugger
I maybe missing the obvious, But can someone please point the right syntax for $this->data['User'] ['status'] = 'temp'; $this->data['User']['signedup'] = 'CURDATE()'; $this->User->save($this->data) The above does not sav