[MAPSERVER-USERS] No Labels on PostGIS Layer

[Guillaume Sueur]

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 <haak at agintegrated.com> 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 <haak at agintegrated.com> 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
>> mapserver-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>