Hi,
I'm trying to join a postgres table to shapefile layer (one-to-many) but I
get no response from identify tool.
Connection to postgres works correctly in a separate php file:
$connstr = "dbname=cbam_db user=postgres password=mypass host=localhost
port=5432";
$dbh = pg_connect($connstr);
if ($dbh)
{
//do nothing... go on...
echo "...ok...";
}
else
{
echo "....troubles....<br>";
}
$sql2 = "SELECT * FROM cbam_table";
$stat2 = pg_exec($dbh, $sql2);
$data2 = pg_fetch_array($stat2, $i2);
for ($i2 = 0; $i2 < $rows2; $i2++)
echo $data2["categoria"];
}
**********
this is my mapfile piece:
LAYER
NAME "censnew"
TYPE line
DATA "censnew"
CLASSITEM "Categ"
TEMPLATE void
METADATA
"DESCRIPTION" "Reticolo di competenza"
"RESULT_FIELDS" "NOME,COMUNE,CATEG,LUNGH"
"RESULT_HEADERS" "Nome,Comune,Categoria,Lunghezza(m)"
"ows_title" "Reticolo di competenza"
"RESULT_JOIN" "pgsql://
postgres:mypass@127.0.0.1:5432/cbam_db||cbam_table@categoria@1@categoria||CATEG||1
"
END
...
...
postgresql table "cbam_table" has one text column named "categoria".
I tried with localhost instead of 127.0.0.1 but query window doesn't
display. All works fine if I comment "RESULT_JOIN" row.
Where am i wrong?
thank you very much
Paolo
------------------------------------------------------------------------------
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
