Hi,
yes i fixed it before my last post. Same Problem: No Output, no
Errormessage.
Greet
Am Freitag, 7. Dezember 2012 23:38:06 UTC+1 schrieb euromark:
>
> a) did you read me remark about your faulty isset()? that is most likely
> the source of your issues. fix it and you will probably be fine
>
> b) there might be. but you dont need to display the sql statement prior to
> the query
> either
> - it is wrong and results in an exception (and will be displayed right
> away for you to see!)
> - it is correct and will end up in your sql debug queries at the bottom of
> your view
> so you can always debug your sql easy and without any fuss
>
>
>
> Am Freitag, 7. Dezember 2012 16:34:58 UTC+1 schrieb Mathias R:
>>
>> 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.
