<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: [postgis-users] Postgis Mapserver Query returns the same item multiple times. </TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>You could try adding 'limit 1' after the WHERE clause (I think) if that is what you want.</FONT>
</P>
<P><FONT SIZE=2>> -----Original Message-----</FONT>
<BR><FONT SIZE=2>> From: James Martin [<A HREF="mailto:martin426@yahoo.com">mailto:martin426@yahoo.com</A>]</FONT>
<BR><FONT SIZE=2>> Sent: Wednesday, November 17, 2004 11:17 AM</FONT>
<BR><FONT SIZE=2>> To: postgis-users@postgis.refractions.net</FONT>
<BR><FONT SIZE=2>> Subject: [postgis-users] Postgis Mapserver Query returns the same item</FONT>
<BR><FONT SIZE=2>> multiple times.</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Hello,</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Any help is greatly appreciated.</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> I'm trying to perform an nquery using the following</FONT>
<BR><FONT SIZE=2>> DATA statement in my mapfile (formatted for e-mail):</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> DATA = "the_geom from</FONT>
<BR><FONT SIZE=2>> (SELECT place.the_geom AS the_geom,</FONT>
<BR><FONT SIZE=2>> place.gid AS gid,</FONT>
<BR><FONT SIZE=2>> place.name AS name</FONT>
<BR><FONT SIZE=2>> FROM place</FONT>
<BR><FONT SIZE=2>> WHERE place.gid=9)</FONT>
<BR><FONT SIZE=2>> AS foo USING UNIQUE place.gid</FONT>
<BR><FONT SIZE=2>> USING SRID=-1"</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Whenever I run this query on a map it works, that is</FONT>
<BR><FONT SIZE=2>> to say there are no error messages and the information</FONT>
<BR><FONT SIZE=2>> I'm expecting is returned.</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> The problem is it returns the information 'N' times,</FONT>
<BR><FONT SIZE=2>> where N is the number of rows in the place table.</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> __________________________________________________</FONT>
<BR><FONT SIZE=2>> Do You Yahoo!?</FONT>
<BR><FONT SIZE=2>> Tired of spam? Yahoo! Mail has the best spam protection around</FONT>
<BR><FONT SIZE=2>> <A HREF="http://mail.yahoo.com" TARGET="_blank">http://mail.yahoo.com</A></FONT>
<BR><FONT SIZE=2>> _______________________________________________</FONT>
<BR><FONT SIZE=2>> postgis-users mailing list</FONT>
<BR><FONT SIZE=2>> postgis-users@postgis.refractions.net</FONT>
<BR><FONT SIZE=2>> <A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users" TARGET="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></FONT>
</P>
</BODY>
</HTML>