How i wrote:
there's only one dump, and this dump shows the query by
$this->findByZipcode();
the other one has no dump and no output.
with your method same problem. no output, no error.
sry, i have to repeat myself: is there a way to display a sql-statement
before cake send this to mysql-server?
i dont have any outputs by binding sql-dump element or any way else.
M.
Am Freitag, 7. Dezember 2012 16:02:11 UTC+1 schrieb euromark:
>
> this is not google code ;) the method I showed you merely has a "working"
> distance query to use as virtual field
> try to compare that to yours
>
> you should be able to get results if you comment out the conditions!
> because then its just a normal query + a mathematical virtual field
> if you still get nothing you have some other issue there
>
> yes, you can easily see your query at the bottom of your view (sql debug
> output when debug mode > 0)
> what query does it print?
>
>
>
> Am Freitag, 7. Dezember 2012 15:47:05 UTC+1 schrieb Mathias R:
>>
>> Hi,
>>
>> sry, but i dont want to use google code. I need to build my own
>> opengeodb-plugin for this app.
>> All vars are filled and cake displays no errors and no log-messages.
>> debug($this->Zipcode->listZipcodesNearBy("19370")); has no output.
>> Cake dumps only first query ($this->findByZipcode) but not second.
>> I dont know how to solve this.
>> Is there a way to get the statement how cake build it? Maybe this way i
>> can find any errors.
>>
>> Am Freitag, 7. Dezember 2012 15:27:16 UTC+1 schrieb euromark:
>>>
>>> no errors? just an empty resultset?
>>> what is the query you result in?
>>>
>>> Until very recently I got a bug in my distance query, as well. Maybe
>>> thats what happens here?
>>> might be just some () missing or $lng instead of $lng somewhere
>>>
>>> To confirm that you could try using my (now correctly working) behavior
>>> to compare it:
>>> http://www.dereuromark.de/2012/06/12/geocoding-with-cakephp/
>>>
>>> $this->setDistanceAsVirtualField($lat, $lng);
>>>
>>> and see if it returns sth now.
>>>
>>>
>>>
>>> Am Freitag, 7. Dezember 2012 15:21:31 UTC+1 schrieb Mathias R:
>>>>
>>>> Hi,
>>>>
>>>> i have a Modelaction where i want to list all zipcodes within a radius
>>>> nearby another zipcode
>>>>
>>>> public function listZipcodesNearBy($zipcode = '', $radius = false,
>>>> $km = 1.609344) {
>>>> if ($data = $this->findByZipcode($zipcode)) {
>>>> $lat = $data['Zipcode']['cityLat'];
>>>> $lng = $data['Zipcode']['cityLng'];
>>>>
>>>> $this->virtualFields['distance'] = '
>>>> ACOS (
>>>> SIN('.$lat.' * PI() / 180) *
>>>> SIN(cityLat * PI() / 180) +
>>>> COS('.$lat.' * PI() / 180) *
>>>> COS(cityLat * PI() / 180) *
>>>> COS(('.$lng.' - cityLng) * PI() / 180)
>>>> ) * 180 / PI() * 60 * 1.1515 * '.$km;
>>>>
>>>> $conditions = array();
>>>> if (isset($radius)) {
>>>> $conditions = array("distance <=", (int)$radius);
>>>> }
>>>> return $this->find('list', compact('conditions'));
>>>>
>>>> }
>>>> return false;
>>>> }
>>>>
>>>> When i don't use virtualfields and comment out $conditions with
>>>> distance <= $radius i get a list of zipcodes. But with virtualfields
>>>> there's no output. no errors too..
>>>>
>>>> Do you see the error? Is there a way to print sql statements build in
>>>> models without action?
>>>>
>>>> Please help.
>>>>
>>>> Greetings from Germany
>>>> M.
>>>>
>>>
--
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 post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
Visit this group at http://groups.google.com/group/cake-php?hl=en.
