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
