[Mapserver-users] PHP/mapscript, PostGIS, and setFilter

[Paul Ramsey]

You could narraw down the potential problem location a little more by 
seeing if your string filter works within a mapfile, without using PHP. 
If it works in the mapfile, it is PHP/Mapscripts fault, if it doesn't 
then it is our fault. :)

P.

Paul Smith wrote:
> Hello all,
> 
> I'm running PHP/mapscript and using PostGIS to store my geography. 
> Trouble is, with the setFilter method under a layer, I can use an 
> expression that checks for an integer, but not a string value. For example:
> 
> $streets->setFilter("gid = 76");
> 
> works, but
> 
> $streets->setFilter("street = 'S Western'");
> 
> gives me an HTTP 500 error. I've also tried using different combinations 
> of single- and double-quotes, like:
> 
> $streets->setFilter('street = "S Western"');
> 
> Nuthin'. Same expression works fine directly under psql. What's up?
>

-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_