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

[Purvis, Charlton]

You could try adding 'limit 1' after the WHERE clause (I think) if that is
what you want.

> -----Original Message-----
> From: James Martin [mailto:martin426 at yahoo.com]
> Sent: Wednesday, November 17, 2004 11:17 AM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Postgis Mapserver Query returns the same item
> multiple 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20041117/b7345b71/attachment.html>