Using = with float is usually a very bad idea. You can look into https://github.com/dereuromark/cakephp-geo and how it does the custom finder for this.
mark Am Sonntag, 9. November 2014 16:39:42 UTC+1 schrieb Radharadhya Dasa: > > Hi, > > Today I pop into something really strange. > > $this->Contacts->find() > ->select(['id', 'name']) > ->where([ > 'lat' => $sameLatLng['lat'], > 'lng' => $sameLatLng['lng'] > ]); > > IT creates the following query: SELECT Contacts.id AS `Contacts__id`, > Contacts.name AS `Contacts__name` FROM contacts Contacts WHERE (lat = > 46.569206 AND lng = 17.68384) > > On DebugKit at the sql log panel there is 0 at num rows colomn. > > If I copy the same query and run it by phpmyadmin I got 4 entries, and > this is the right result. > > Everything deleted from /tmp/cache. I working on the same database. > > Any idea??? > > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
