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