hi ,
please i want to join database postgres in pmapper to show some information
this is my script map but it doesn't work i don't know where is the
problem:
LAYER
NAME "shape1"
TYPE POLYGON
DATA "shape1"
TEMPLATE "ttt"
#TRANSPARENCY 50
CLASS
NAME "shape1"
STYLE
COLOR 153 255 153
OUTLINECOLOR 51 51 51
END
END
METADATA
"DESCRIPTION" "shape1"
"RESULT_FIELDS" "id,name,middle,last,address"
"RESULT_HEADERS" "id,name,middle,last,address"
"RESULT_JOIN"
"pgsql://postgres:root@localhost:/test||users@id@0@id,name,middle,last,address||CODE||0"
END
END #layer
id,name,middle,last,address : are columns from my database.
CODE: DB_join_field
id:SHAPE_join_field
thanks to all
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
