mercredi 1 février 2017

whereBetween and ajax call?

I have this part of code where i get an url:

for (var key in resultData) {
        if (resultUrlParams != "") {
            resultUrlParams += "&";
        }

        resultUrlParams += key + "=" + resultData[key];
    }

Url looks something like this now :

publishing_types=Selling&price=0,300000&area=0,300000

Problem is now in query where i use something like this:

    if($key == "price"){
      $query->whereBetween('price',$option);
    }

And then i get an error :

<>: 7 ERROR: bind message supplies 2 parameters, but prepared statement "pdo_stmt_00000024" requires 3 (SQL: select count(*) as aggregate from "properties" where exists (select * from "publishing_types" where "publishing_types"."id" = "properties"."publishing_type_id" and "name" in (Selling)) and "price" between 0,300000 and ?)

Im using postgreSql



from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2kS4hFw
via IFTTT

Aucun commentaire:

Enregistrer un commentaire