[postgis-users] Postgis Mapserver Query returns the same itemmultiple times.

[TECHER Jean David]

Hi

Did U try your query without mapserver (i.e psql yourdatabase ....) in order
to see if the query is good before call mapserver.???

perhaps u have done a error in your php code!!!
----------------------------------------------------------------
TECHER Jean David
Responsable Informatique 01MAP
e-mail: davidtecher at yahoo.fr
site perso : http://techer.pascal.free.fr/postgis/
site pro: http://www.01map.com/download/
------------------------------------------------------------
----- Original Message -----
From: "James Martin" <martin426 at yahoo.com>
To: <postgis-users at postgis.refractions.net>
Sent: Wednesday, November 17, 2004 5:17 PM
Subject: [postgis-users] Postgis Mapserver Query returns the same
itemmultiple times.


> Hello,
>
> Any help is greatly appreciated.
>
> I'm trying to perform an nquery using the following
> DATA statement in my mapfile (formatted for e-mail):
>
> DATA = "the_geom from
> (SELECT place.the_geom AS the_geom,
>              place.gid AS gid,
>              place.name AS name
>              FROM place
>              WHERE place.gid=9)
>              AS foo USING UNIQUE place.gid
>              USING SRID=-1"
>
> Whenever I run this query on a map it works, that is
> to say there are no error messages and the information
> I'm expecting is returned.
>
> The problem is it returns the information 'N' times,
> where N is the number of rows in the place table.
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>