Re: Model-query not working with virtualFields

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 cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.