You misunderstand what the FILTER tag in mapserver does for PostGIS queries. Read up about it and you will figure it out.

But if you are already using set("data",...), why not just specify the entire query?

$this_layer->set("data","the_geom from ( SELECT gid, the_geom FROM europe_country WHERE name='England') AS foo USING UNIQUE gid USING srid=-1");



nickthegreek- wrote:
kyle i tried this

$this_layer1->setFilter("name='England''");
 $this_layer1->set("data","the_geom from ( select gid, the_geom from
europe_country where name=".getFilter(name).") as foo using unique gid using
srid=-1");


how would i take the parameter whick is int the filter? name?

--

 Kyle Wilcox
 NOAA Chesapeake Bay Office
 410 Severn Avenue
 Suite 107A
 Annapolis, MD 21403
 office: (410) 295-3151
 [EMAIL PROTECTED]

 A: It takes over twice as long to understand the conversation.
 Q: What's wrong with top-posting?
 A: Top-posting.
 Q: What's the worst thing about plain text email discussions?
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to