just an idea before coffee...
DATA "field_boundary from (select fb.field_id as field_id,
>> fb.field_id as
>> OID, fb.field_boundary as field_boundary, fb.acres as acres,
>> f.field_name as
>> field_name from field_boundary fb, fields f where
>> fb.field_id=f.field_id) as
>> field_boundary"
doesn't it make a lot of 'field_boundary' for different things (table,
geo field...)
what happens if you write:
DATA "the_geom from (select fb.field_id as field_id,
fb.field_id as
OID, fb.field_boundary as the_geom fb.acres as acres,
f.field_name as
field_name from field_boundary fb, fields f where
fb.field_id=f.field_id) as
myjoin "
Guillaume
Paul Ramsey a écrit :
There's really nothing special going on. Send your map file and a
table dump and I will attempt to duplicate, but frankly... if it was a
general problem we'd have heard of it by now.
P.
On Mon, Jun 23, 2008 at 6:31 PM, osprey44 <[EMAIL PROTECTED]> wrote:
Paul,
I originally started with just trying to view acres, which lives in
field_boundary table which has the geometry. To triple check, I just
removed reference to the field table and changed the labelitem to "acres".
Still no joy. Is there any special DB setting that is required to return
the label query data; similar to what needs to be done to utilize the
geometry columns?
Chris
Work it back to basics. Does it work without the join? There's nothing
obviously wrong with your map entry, that I can eyeball.
P
On Mon, Jun 23, 2008 at 2:35 PM, osprey44 <[EMAIL PROTECTED]> wrote:
Yes, that particular ID should return a name of "Madison". Also, I
attempted
to use acres and that column also has a value. I have labeled layers that
have come from shapefiles in nearly the same manner (minus the postgis
connection), and their labels print properly.
--
View this message in context:
http://www.nabble.com/No-Labels-on-PostGIS-Layer-tp18078514p18081915.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
