Radicore Forum: Bug Reports » different results in queries

Home » RADICORE development » Bug Reports » different results in queries

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: different results in queries [message #628 is a reply to message #627]

Tue, 13 February 2007 15:09

stephenboey
Messages: 54
Registered: January 2007

Member

echo and print_r would not work if redirected to another page. So can't really see whats happening in cm_post_recordupdate.

I found a way to output the variable values into sql files.

// get all children of this node
$this->sql_select = 'role_id';
$this->sql_from = 'mnu_role';
$where = "role_id_snr='".$role_id."'";
$children_rowdata = $this->_dml_getData($where); <*** query A

$A = count($children_rowdata); <*** count A
$this->sql_select = 'role_id';
$this->sql_from = 'mnu_role';
$where = 'role_id_snr='.$A;
$children_rowdata3 = $this->_dml_getData($where); <**** query B

SELECT SQL_CALC_FOUND_ROWS role_id FROM mnu_role WHERE role_id_snr='GLOBAL' ORDER BY mnu_role.role_id asc LIMIT 1 OFFSET 0 LOCK IN SHARE MODE=>Count=2
SELECT SQL_CALC_FOUND_ROWS role_id FROM mnu_role WHERE role_id_snr=1 ORDER BY mnu_role.role_id asc LIMIT 1 OFFSET 0 LOCK IN SHARE MODE=>Count=0

Seems "query A" found 2 records, but when I count the records returned in "count A" its say only 1 record. Something is not right here, I sense this could be a bug in _dml_getData. What do you think?

Report message to a moderator

[Message index]

		different results in queries By: stephenboey on Mon, 12 February 2007 19:44
		Re: different results in queries By: AJM on Tue, 13 February 2007 04:25
		Re: different results in queries By: stephenboey on Tue, 13 February 2007 08:58
		Re: different results in queries By: AJM on Tue, 13 February 2007 09:16
		Re: different results in queries By: stephenboey on Tue, 13 February 2007 15:09
		Re: different results in queries By: AJM on Tue, 13 February 2007 20:02
		Re: different results in queries By: stephenboey on Tue, 13 February 2007 20:36
		Re: different results in queries By: AJM on Wed, 14 February 2007 04:34
		Re: different results in queries By: stephenboey on Wed, 14 February 2007 08:13
		Re: different results in queries By: AJM on Wed, 14 February 2007 08:56
		Re: different results in queries By: stephenboey on Wed, 14 February 2007 09:02
		Re: different results in queries By: AJM on Wed, 14 February 2007 09:47
		Re: different results in queries By: stephenboey on Wed, 14 February 2007 10:22
		Re: different results in queries By: AJM on Wed, 14 February 2007 10:50
		Re: different results in queries By: stephenboey on Wed, 14 February 2007 11:03

Previous Topic:	dml_updateSelection
Next Topic:	not able to search 'Task Id'

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Nov 25 12:35:10 EST 2024

Total time taken to generate the page: 0.01265 seconds