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 will not work with Postgresql 8.0
> if you get the error > "Relation Anagrafica_Punti_Prelievo does not exist" > then the table is definitively not existing. Postgres supports this kind > of query for sure. But PG has sort of strange behaviour when using upper > case characters for tables or columns. Try converting everything in > lower case and run it again. I use both versions 1.9.4 and 1.1.0, and 1-to-1 relation works, but the name of the joined fields is not displayed. Now I am also able to make a 1-to-many relation, but as you say, there are some problems resulting in a confused graphical rapresentation. When do you think you will adjust this part of code? I could also be available to restructuring the code on my own, and obvioulsy give the mods to all other users :) There is an interest in such a feature? > I checked the code and for 1-to-1 relations it works without problems. > For 1-to-many there is a slight problem that would need some > re-structuring of the code. The data are displayed, but just everything > in one row. In your case you do not get a query result (which would be > an array) but either an error object or error code (what you can print > out, eg. with "print_r($data);" in line 216. > > In general it's always a bit difficult to find errors without having the > data and the map file available. I even do not know the version or build > of pmapper you are using. -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Proteggi al tua casa:con FULL CASA di RAS bastano anche solo 50 Cent. al giorno. Fai subito il tuo preventivo online! Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=4026&d=20060120
