Hi,
I am trying to make a join between a postgis layer and a postgres table
without geometry, but I don't get any result in the query zone.
My mapfile is the following:
LAYER
CONNECTIONTYPE postgis
NAME "landsat"
CONNECTION "host=localhost dbname=mydb_postgis user=postgres
password=isa0400"
TYPE polygon
DATA "the_geom from landsat"
METADATA
"DESCRIPTION" "Grid Landsat"
"RESULT_FIELDS" "pr"
"RESULT_HEADERS" "pr, archivo"
"RESULT_JOIN"
"pgsql://postgres:[EMAIL PROTECTED]/mydb_postgis||[EMAIL PROTECTED]@[EMAIL
PROTECTED]||pr||1"
END # Metadata
CLASS
Name 'Escenas Landsat'
#COLOR 171 55 10
OUTLINECOLOR 180 180 180
TEMPLATE void
END # Class
END #LAYER
Is it working the one2many joins in p.maper3.1 beta3?
Could be any problem with indexes?
I also tried to make the join in the data tag, as follows. I can view the
result in the map zone but I continue without any result in the query
zone.
LAYER
CONNECTIONTYPE postgis
NAME "landsat"
CONNECTION "host=localhost dbname=mydb_postgis user=postgres
password=isa0400"
TYPE polygon
DATA "the_geom from (SELECT * FROM landsat INNER JOIN principal ON
landsat.pr = principal.pr) as foo using unique gid using SRID=4326"
METADATA
"DESCRIPTION" "Grid Landsat"
"RESULT_FIELDS" "pr"
"RESULT_HEADERS" "pr, archivo"
#"RESULT_JOIN"
#"pgsql://postgres:[EMAIL PROTECTED]/mydb_postgis||[EMAIL PROTECTED]@[EMAIL
PROTECTED]||pr||1"
END # Metadata
CLASS
Name 'Escenas Landsat'
#COLOR 171 55 10
OUTLINECOLOR 180 180 180
TEMPLATE void
END # Class
END #LAYER
Thank you very much,
Isa
--
View this message in context:
http://www.nabble.com/join-to-database-tables-tf3468686.html#a9678562
Sent from the pmapper users mailing list archive at Nabble.com.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
