Re: [Rlib-users] odd rlib_add_query_as() behaviour

[Bob D. <bd...@si...>]

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
> 
> 
>