how to join more table

[Marco-57]

Hi,

I looked at the function _getJoinProperties and I saw that implement
the join only with one table.
Is there another way? Or I change the function to read more
RESULT_JOIN using joinList as multidimensional arrays (could be an
added feature)?

thanks

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
pmapper-users mailing list
pmapper-users@...
https://lists.sourceforge.net/lists/listinfo/pmapper-users

[Armin Burger-2]

On 10/11/2009 18:02, Marco wrote:

> Hi,
>
> I looked at the function _getJoinProperties and I saw that implement
> the join only with one table.
> Is there another way? Or I change the function to read more
> RESULT_JOIN using joinList as multidimensional arrays (could be an
> added feature)?
>
> thanks
>

Marco

you could do the joins already inside the database.

Since there are quite a lot of alternative possibilities to use joins
(directly in Postgis or Oracle spatial, map file, OGR layers) I don't
see such a big need for it in p.mapper. 1-n joins eg. are not supported
in the p.mapper definition, and I doubt they will be, for the above reasons.

armin


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
pmapper-users mailing list
pmapper-users@...
https://lists.sourceforge.net/lists/listinfo/pmapper-users

[Marco-57]

Thanks for your reply.
My problem is that all queries contain spaces in the name, I solved by
changing the SELECT in squery.php in this way:

$this->sql = "SELECT " . $this->joinFields . " FROM \"$fromTable\"
WHERE $fromField=";



2009/11/10 Armin Burger <armin.burger@...>:

> On 10/11/2009 18:02, Marco wrote:
>> Hi,
>>
>> I looked at the function _getJoinProperties and I saw that implement
>> the join only with one table.
>> Is there another way? Or I change the function to read more
>> RESULT_JOIN using joinList as multidimensional arrays (could be an
>> added feature)?
>>
>> thanks
>>
>
> Marco
>
> you could do the joins already inside the database.
>
> Since there are quite a lot of alternative possibilities to use joins
> (directly in Postgis or Oracle spatial, map file, OGR layers) I don't
> see such a big need for it in p.mapper. 1-n joins eg. are not supported
> in the p.mapper definition, and I doubt they will be, for the above reasons.
>
> armin
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
pmapper-users mailing list
pmapper-users@...
https://lists.sourceforge.net/lists/listinfo/pmapper-users