From: Al A. <aa...@ge...> - 2005-04-01 16:55:02
|
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 |