Hi,
The first query added to RLIB is the "Main Loop" Query. That drives the
number of ROWS.
In the <Report>
tag you can have a query="'something_else'" to override this
On Fri, 2005-04-01 at 10:54 -0600, Al Arzaga wrote:
> Hi, again
>
> I'm trying to implement something similar to that of RLIB's
> flow_part.php/flow_part.xml example.
>
> What I'm seeing is a weird behavior where if I were to switch the order
> of the rlib_add_query_as() calls, I get different results. The output
> of the second result set ends up displaying only as many as the row
> count of the first result set.
>
> In the context of the flow_part example, for instance, you have the
> arrays data, with 5 rows in the result set, and moredata, with 59. My
> resulting output would show 5 rows for both sets of data in the
> resulting output. If I were to switch the order of the
> rlib_add_query_as() calls, I'd get all sets of data to appear.
>
> Now, this isn't what I see with _the_ example code. I'm only
> explaining my problem in terms of the example code just so that people
> can get the general idea.
>
> What I'm wondering is if others have seen this problem. PHP code
> snippet:
>
> $rlib = rlib_init();
> rlib_add_datasource_array($rlib, "local_array");
> rlib_add_query_as($rlib, "local_array", "main_array", "main_array");
> // switching this with
> rlib_add_query_as($rlib, "local_array", "op_array", "op_array");
> // this gives different results.
> rlib_add_report($rlib, "main.xml");
> rlib_set_output_format_from_text($rlib, $format);
> rlib_execute($rlib);
>
> Size of main_array result set is 1. Size of op_array result set is 78.
> Depending on which is called first, I get either a single listing for
> op_array in the report, or all 78.
>
>
> -Al
>
>
>
|
