carlo.calvino at email.it wrote:
> Dear Armin,
> what you say is perfectly right. I switched all the names into
> lower-case, and now it works!
> About the 1-to-many relation, what do you think to do?
I will fix it, sooner or later...
/a
2 PM
Subject: Re: [Pmapper-users] Problems with JOIN
> pmapper works with Postgres 7.3, 7.4, 8.0 and 8.1 and so on. The basic
query
> syntax in PG has not changed since eternities. But as I said, PG has a
> strange behaviour towards using upper case letters in names, it\'s a bit
like
> Betreff: Re: [Pmapper-users] Problems with JOIN
> Datum: Fri, 20 Jan 2006 13:10:30 +0100
>
> Further investigations into this stuff suggests me that my problem with
> Postgresql is not related to the uppercase/lowercase syntax, but with
> apostrophes.
> In fact this query
Further investigations into this stuff suggests me that my problem with
Postgresql is not related to the uppercase/lowercase syntax, but with
apostrophes.
In fact this query is working:
SELECT "PPID","PPNom" FROM "Anagrafica_Punti_Prelievo" WHERE "GEOID"=1884
Then I think that, by default, pmapper
annot Use a scalar value as an array in squery.php on line 221".
>
> This type of relation is important for me, and I think it is what ArcView
> calls "Relate". Thank you very much for your help.
>
>
> - Original Message -
> From: "Armin Burger
"Relate". Thank you very much for your help.
- Original Message -
From: "Armin Burger" <[EMAIL PROTECTED]>
To:
Cc:
Sent: Wednesday, January 18, 2006 3:30 PM
Subject: Re: [Pmapper-users] Problems with JOIN
> Try to write out the SQL string that is sent to the
"Relate". Thank you very much for your help.
- Original Message -
From: "Armin Burger" <[EMAIL PROTECTED]>
To:
Cc:
Sent: Wednesday, January 18, 2006 3:30 PM
Subject: Re: [Pmapper-users] Problems with JOIN
> Try to write out the SQL string that is sent to the DB,
--
> Von: carlo.calvino at email.it
> An: pmapper-users at faunalia.it
> Betreff: [Pmapper-users] Problems with JOIN
> Datum: Wed, 18 Jan 2006 13:03:02 +0100
>
> Hello Armin, hello all
> I am having problems with joining. My DBMS is PostgreSQL, and this is the
Hello Armin, hello all
I am having problems with joining. My DBMS is PostgreSQL, and this is the
METADATA line of the layer:
RESULT_JOIN
\"pgsql://postgres:miapass at localhost/marco||Anagrafica_Punti_Prelievo at
[EMAIL PROTECTED] at PPID,PPNom||GEOID||0\"
That is, I have a layer with a field c
