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

[Al A. <aa...@ge...>]

When adding a query="'something_else'" to the report's xml 
it is from that query that the report part iterates through a data set.

Is there a way to have a second query's data set be included in that report
part so that it, too iterates, through the report?  They both will contain
the same number of rows/records.




-----Original Message-----
From: Bob Doan [mailto:bd...@si...]
Sent: Friday, April 01, 2005 12:07 PM
To: Al Arzaga
Cc: RLIB USERS
Subject: Re: [Rlib-users] odd rlib_add_query_as() behaviour


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



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Rlib-users mailing list
Rli...@li...
https://lists.sourceforge.net/lists/listinfo/rlib-users