dimanche 29 novembre 2015

laravel having: Column not found

my following code is like this:

$places = DivePlace::selectRaw("*,(st_distance_sphere( POINT(".$lon.",".$lat.") ,  point(lon, lat))/1000) as distance")
    ->havingRaw("distance < ".$radius)
    ->orderBy("distance")
    ->paginate(10);

without the "havingRaw" everything is good. After adding it, the following error came up:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'distance' in 'having clause' (SQL: select count(*) as aggregate from dive_places having distance < 300)

Any solution?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire