It *is* a Mapscript error. I thought it had been fixed in MS 4.10.2. In 
my opinion this error should just happen after an attribute query . But 
you don't say this explicitly. In any case report it to the MS 
developers and ask when it will be fixed.

I never use filters like that on Postgis, but like

FILTER "c_farm = 8010"

If it still does not work try

FILTER '"c_farm = 8010"'

armin


Gabe wrote:
> Hi Armin, Pmapper-users
> 
> This is probably a mapscript or mapserver thing but ...
> 
> I am using pmapper 3.1, on mapscript 4.10.2, php 5.2.3.  I have a layer that
> works fine unfiltered but when I try to put a plain text filter on it I get
> this error:
> 
> [27-Jun-2007 14:39:06] PHP Warning:  [MapServer Error]: msDrawMap(): Failed
> to draw layer named 'Paddocks'.
>  in D:\dev\nusphere\pmapper\incphp\map.php on line 316
> [27-Jun-2007 14:39:06] PHP Warning:  [MapServer Error]: prepare_database():
> Error executing POSTGIS DECLARE (the actual query) statement: 'DECLARE
> mycursor BINARY CURSOR FOR SELECT
> "isfallow"::text,"c_farm"::text,"c_linkcode"::text,asbinary(force_collection
> (force_2d(the_geom)),'NDR'),oid::text from p.v_pad_export WHERE (8010) and
> (the_geom && setSRID( 'BOX3D(153.403139097172
> -28.30966067574,153.431890713834 -28.28477832426)'::BOX3D,-1) )' 
> 
> Postgresql reports the error as 'ERROR:  argument of AND must be type
> boolean, not type integer
> '
> 
> The Filter is:
> 
> FILTERITEM "c_farm"
> FILTER "8010"
> 
> The error happens because of this part of the query
> ... WHERE (8010) ...
> It should read WHERE (c_farm='8010')
> 
> Any help will be much appreciated 
> 
> Thanks
> Gabe
> 
> 

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Reply via email to