Dear Armin, I looked inside string $sqlRun, its value is "SELECT PPID,PPNom,GEOID FROM Anagrafica_Punti_Prelievo WHERE GEOID=1884". I passed this code into Postgresql 8.0 and it says:" Relation Anagrafica_Punti_Prelievo does not exist". This type of sql code doesn't seem to be supported by Postgresql 8. So, I moved the table into an Access database, updating the map file with:
RESULT_JOIN "odbc://'':''/localhost at prova||Anagrafica_Punti_Prelievo at [EMAIL PROTECTED] at PPID,PPNom||GEOID||0" It does work! But the query doesn't show the two cells with the name of the joined fields. Moreover, if I join to a table with a 1-to-many relation, I get the same error: "Cannot 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" <[EMAIL PROTECTED]> To: <carlo.calvino at email.it> Cc: <pmapper-users at faunalia.it> 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, something like after > line 292 > > error_log($sqlRun); > > and see in the PHP error log for the command, then run it dircetly on the > database and see if the command executes without erors. > > if yes, write out the result ($data) from the query after line 211; you can > use the printDebug() function from common.php, just modify the path of the > debug file. > > I have to admit that i haven't used the join function since about 2 years, > but the code should not have changed since and it had been working. > > Armin -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Suonerie polifoniche, loghi, sfondi colorati, giochi multimediali, ecco tutto quello che trovi nella sezione email.it dedicata ai cellulari Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=3116&d=20060119
