[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis] Querying mapserver with data from PostGIS table
From:       "Paul Ramsey" <pramsey () refractions ! net>
Date:       2001-10-05 14:48:22
Message-ID: 200110051448.f95EmuW15990 () lion ! animals
[Download RAW message or body]

Use lower case for the attribute names:

[description] fpr example...

Paul

Ewa Patrowicz <ewap@arges.pl> said:

> I have a situation:
> - shape "xxx" with attributies :
> geometry, ident, description
> 
> I constructed map layer 
> 
> LAYER
> NAME "ss"
> DATA "xxx"
> HEADER "xxx_hdr.htm"
> TEMPLATE "xxx_tmpl.htm"
> FOOTER "xxx_ftr.htm"
> CLASS
> ...
> END
> END
> 
> When querying this layer I obtained good results. For example
> "1-st description"  
> "2-nd description"
> "71-th description"
> 
> Trouble is when I try using postgis table
> - table "xxxx" with columns : 
> geometry, ident, description
> 
> Table contained the same data as the shape above.
> I constructed map layer 
> 
> LAYER
> NAME "sss"
> CONNECTIONTYPE postgis
> CONNECTION ...
> DATA "geometry FROM xxxx"
> HEADER "xxx_hdr.htm"
> TEMPLATE "xxx_tmpl.htm"
> FOOTER "xxx_ftr.htm"
> CLASS
> ...
> END
> END
> 
> I used the same template query files xxx_*.htm as the names of columns and \
> attributies were the same. 
> When querying this layer I obtained a list of labels instead of values.
> Using the same circumstances :
> [DESCRIPTION]
> [DESCRIPTION]
> [DESCRIPTION]
> 
> 
> What could I do for obtaining the correct result in this situation?
> 
> Ewa.
> 



-- 
  Paul Ramsey
  pramsey@refractions.net
  Refractions Research Inc
  (250) 885-0632

 

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Pinpoint the right security solution for your company- Learn how to add 128- bit \
encryption and to authenticate your web site with VeriSign's FREE guide! \
                http://us.click.yahoo.com/yQix2C/33_CAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe@yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 


[prev in list] [next in list] [prev in thread] [next in thread]