I found the solution of my problem: Just only use the static method DboSource::expression()
http://api20.cakephp.org/class/dbo-source#method-DboSourceexpression Em domingo, 8 de abril de 2012 07h38min19s UTC-3, Everton Inocencio escreveu: > > I'm using CakePHP 2.1.1 and PostgreSql 9.1. > > And I'm trying to use the save() method of my Model, but one column need > to use a DB function to convert a value to insert. > > Ex: > *Array(* > *'Ponto' => Array(* > * 'id' => '',* > * 'title' => ' default title ',* > * 'ponto' => "ST_GeomFromText('POINT(1 1)', 4326)"* > *)* > *);* > > My field 'ponto' has to execute a ST_GeomFromText() function before put > value, > but the generated SQL looks like this: > > *INSERT INTO pontos (title, ponto, created) VALUES ('default title', > 'ST_GeomFromText(\'POINT(1 > 1)\', 4326)', NOW() );* > But this not works. > > Has a way to cakephp not to escape my value as a string ? > > *INSERT INTO pontos (title, ponto, created) VALUES ('default title', > ST_GeomFromText('POINT(1 1)', 4326) , NOW() );* > I want this * > * > * > * > Thanks, > sorry for my bad english :x > Em domingo, 8 de abril de 2012 07h38min19s UTC-3, Everton Inocencio escreveu: > > I'm using CakePHP 2.1.1 and PostgreSql 9.1. > > And I'm trying to use the save() method of my Model, but one column need > to use a DB function to convert a value to insert. > > Ex: > *Array(* > *'Ponto' => Array(* > * 'id' => '',* > * 'title' => ' default title ',* > * 'ponto' => "ST_GeomFromText('POINT(1 1)', 4326)"* > *)* > *);* > > My field 'ponto' has to execute a ST_GeomFromText() function before put > value, > but the generated SQL looks like this: > > *INSERT INTO pontos (title, ponto, created) VALUES ('default title', > 'ST_GeomFromText(\'POINT(1 > 1)\', 4326)', NOW() );* > But this not works. > > Has a way to cakephp not to escape my value as a string ? > > *INSERT INTO pontos (title, ponto, created) VALUES ('default title', > ST_GeomFromText('POINT(1 1)', 4326) , NOW() );* > I want this * > * > * > * > Thanks, > sorry for my bad english :x > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
