it still might be helpful to know which version/build of p.mapper you're using...
Nevertheless, try the attached 2 query files. The older query.php did not work well with Postgis layers in UTF8 encoding. The squery.php faced a bug of PHP-Mapscript and filter definitions (getFilter() returns a literal "(null)" if no filter defined) for Postgis layers. I put a workaround for the latter. What should not happen is that the values and fields are confused, for this I guess an error in configuration. Uncomment in squery.php the line 576 and run the SQL command directly on your DB. In any case you need an OID field for PG layer attribute queries to work. I already mentioned on this list, that for whatever strange reasons the PG developers dropped the OID field as default since version 8.1, which causes problems in p.mapper. Maybe a good entry for the Wiki FAQ... armin PS: please do not use HTML formatted mails for this mailing list. hello all, i'm trying to use a multiple query in js.custom.php with a postgis layer but it doesn't work. when i use only one attribute i have no data result; when i use two attributes it give me an error (it is searching for a column in my database named as the second word i insert for the search). i have no problem with a shp file. what i need? i read something about oid. what i have to create: an index or a column? is there something to insert in the mapfile (like DATA ... using unique)? thanks Alessandro Bezzi Arc-Team (Archaeology and Open Source) http://www.arc-team.com > _______________________________________________ > Pmapper-users mailing list > Pmapper-users at faunalia.it > http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users > -- Echte DSL-Flatrate dauerhaft f?r 0,- Euro*! "Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl -------------- next part -------------- A non-text attachment was scrubbed... Name: query.zip Type: application/zip Size: 16455 bytes Desc: not available Url : http://faunalia.it/pipermail/pmapper-users/attachments/20060307/3e9c0a49/attachment.zip
