Re: Query

Si usas la v2 tendrás que usar este metodo:

$this->Customer->query("SELECT * FROM pictures LIMIT 2;");

http://book.cakephp.org/2.0/en/models/retrieving-your-data.html#model-query

Te recomiendo que uses la versión 3.

Enviado con MailTrack

Saludos

Christian Quispe

Geek and Developer

Miembro:  GDG Lima (Google Developer Group Lima)

Portafolio: www.oxicode.io

¿A quién le enseñan sus aciertos?, si yo aprendo de mis errores constantemente...

2015-07-15 7:06 GMT-05:00 Hugo Fabricio <me@hugofabricio.com>:

Hi,

Can anyone help me for this query in cakephp 2 format?

SELECT * FROM  `app_customers` AS `Customer` WHERE id IN ( SELECT DISTINCT (customer_id) FROM  `app_buildings`)

Thanks

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.