PostGIS beginner question

[Paul Ramsey]

It's a bit of a pain. See the Mapserver examples end of my tutorial  
at OSGIS/MUM 2005
P

On 21-Apr-06, at 11:54 AM, Chip Taylor wrote:

> We are just getting our feet wet with PostGIS, running Mapserver as  
> CGI on IIS6.  We have a basic question.  Below is an example of our  
> layer from the mapfile.
>
>
>
> LAYER
>
>           NAME "testlayer"
>
>           TYPE POLYGON
>
>           CONNECTIONTYPE POSTGIS
>
>           CONNECTION "dbname=mydb user=myuser password=mypw  
> host=myserver port=5432"
>
>           DATA "wkb_geometry from (select * from getcounty 
> (-122.4419846666667,47.250942883333)) As myTable USING UNIQUE  
> ogc_fid using SRID=32767"
>
>
>
>           STATUS default
>
>           TRANSPARENCY 50
>
>           LABELITEM "population"
>
>           CLASS
>
>                       EXPRESSION ([population] > 0)
>
>                       COLOR 255 245 220
>
>                       MINSCALE 0
>
>                       MAXSCALE 100000000
>
>                       STYLE
>
>                                   OUTLINECOLOR 25 25 45
>
>                                   SYMBOL 'cartoline'
>
>                                   SIZE 1
>
>                       END
>
>                       LABEL
>
>                                   FONT "Arialbd"
>
>                                   TYPE TRUETYPE
>
>                                   ANTIALIAS TRUE
>
>                                   COLOR 0 0 0
>
>                                   OUTLINECOLOR 255 255 220
>
>                                   SIZE 8
>
>                                   MINDISTANCE 300
>
>                       END
>
>           END
>
>           PROJECTION
>
>                       "init=epsg:4269"
>
>           END
>
> END # postGIS test
>
>
>
>
>
> The question is, when the user clicks on the map, how do we pass  
> the location of that click into PostGIS as a parameter.  Thanks in  
> advance for your help.
>
>
>
> Chip Taylor
>
>
>
>