[postgis-users] Joined, queried or table views in Mapserver Mapfile.

[Obe, Regina]

Not sure I understand your question.  I've never had problems displaying
data from joined tables in either right or left table via Mapserver as
long as I alias the field names in cases where the names could be found
in both tables or avoid doing something like table.*.
 
Can you provide an example of your layer?
 
Thanks,
Regina
 
 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Giuseppe Molinario
Sent: Wednesday, June 27, 2007 4:44 AM
To: PostGIS Users Discussion
Subject: [postgis-users] Joined, queried or table views in Mapserver
Mapfile.


Hi everyone, 

Wondering if this question is not better suited for a Mapserver forum,
I'll post it anyway in case someone has an easy solution... 

My problem is this: I am usind the following layer in a Mapserver based
application. The DATA connection works, objects are visible on the map
in their correct place and symbology, however the query of the postgis
table works only if I name the columns of the LEFT table in the RESULT
FIELDS. How do i get the thing to query also my Columns from the joined
table? Why on earth would i have the same problem usind the DATA
connected to a table view? 

Thanks, 

Giuseppe 




-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070627/b6afcaed/attachment.html>