Thanks Julian, I'm not using any satellite fields (like foo and bar) in this simple, stripped-down example, but I am still getting the weird behavior... I'll try using a different unique identifier and see if that helps.
Thanks again, Matt On Tue, 12 Feb 2008 11:58:48 -0500, Julien-Samuel Lacroix <[EMAIL PROTECTED]> wrote: >Hi, > >I think you need to specify in the sub-select every field you want to >use in your query results. For example: >DATA "the_geom from (select the_geom, foo, bar from shp_prct) as foo >using unique oid using SRID=-1" > >This will allow you to display/use the foo and bar column. > >Julien >PS: Note that using the geometry field as the unique id is probably not >the best way to go. Usually you will have a gid or a oid field which is >unique. > >[EMAIL PROTECTED] wrote: >> Hi, >> >> A while back, I posted a question like this to the group, and got an answer >> that worked for me: >> >> http://lists.umn.edu/cgi-bin/wa?A2=ind0705&L=mapserver-users&D=0&O=D&T=0&P=5373 >> >> I was able to get correct results by making a simple query. Now, however, I >> need to use a more complex query to return results. >> >> The problem is this... I have a template and a map file with a layer that >> uses that template. When the DATA attribute is: >> >> DATA "the_geom from shp_prct" >> >> the query works fine and i get my template back appropriately filled out. >> When I use the more complex but equivalent formulation: >> >> DATA "the_geom from (select the_geom from shp_prct) as foo using unique >> the_geom using SRID=-1" >> >> The result is the following: >> >> Content-type: text/html >> >> >> <HTML> >> <HEAD><TITLE>MapServer Message</TITLE></HEAD> >> >> <!-- MapServer version 5.0.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG >> OUTPUT=WBMP OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG >> SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT >> SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER >> SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS >> INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE --> >> >> <BODY BGCOLOR="#FFFFFF"> >> </BODY></HTML> >> >> >> Just to note, the query I really need isn't the second one verbatim, but >> uses the form of "select the geom from (<query>) as foo ...". >> >> I'm omitting the rest of the info assuming it isn't important at this time, >> but will supply it if someone thinks that it is key to solving this... >> >> Any ideas? >> >> Thanks, >> Matt >> > >-- >Julien-Samuel Lacroix >Mapgears >http://www.mapgears.com/
