Loading information from postgresql

[Bart van den Eijnden]

Hi,

you can use a subselect in the DATA statement, e.g.:

DATA "the_geom from (select the_geom, ..., ... from mytable where .....)"

Or you can probably define a FILTERITEM and FILTER on your LAYER. See MAP
file reference for that.

Best regards,
Bart

On Tue, 15 Feb 2005 13:12:09 -0600, Carlos Eduardo Sibaja Salazar
<carloseduardo at COSTARRICENSE.CR> wrote:

> Hi. I installed postgresql, postgis and mapserver.
>
> Now i can load maps from the database and show this maps with mapserver
> in a
> browser.
>
> I'm using this line to do it: DATA "the_geom from mytable"
>
> I can see the map. But now i want to show an specific information. For
> example,
> i have information about all the towns in my country, and i want to show
> in the
> map only some towns, using a "where" sentence. Something like DATA
> "the_geom
> from mytable where ..."
>
> Please tell me if someone knows a good tutorial or guide where i can
> learn to do
> this.
>
> Thanks.!!
>
> _______________________________________
> Yo me registré en www.costarricense.cr



--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/