FYI this thread was also started on the Mapserver mailing list.
$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:
i have map who takes the data from a database
in the database there is a column "name"
my data are be shown with
LAYER
NAME "country"
TYPE POLYGON
STATUS ON
CONNECTIONTYPE postgis
CONNECTION "host=localhost dbname=postgis user=postgres
password=d3klw7 port=5432"
DATA "the_geom from europe_country using unique gid using
srid=-1"
LABELITEM "name"
what i wanna is.. i have a menu who takes all the countries from the column
name...
if i select a country
eg.greece
how i could change the statement in the mapfile
DATA "the_geom from europe_country using unique gid using srid=-1"
with the statement
DATA "the_geom from europe_country where name=greece using unique gid using
srid=-1" so to be shown only greece??? pls help me..i need to finish my
diploma with taht
eg..i knnow if we wanna to change the status of a layer we use that
$this_layer = $map->getLayerByName('europe cities');
$this_layer->set('status', MS_ON);
sth similar like the above to change the statement of data?
--
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?
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
