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 #630 is a reply to message #629]

Tue, 13 February 2007 20:36

stephenboey
Messages: 54
Registered: January 2007

Member

like I said Tony print_r cannot display the contents because your framework redirects the page. This is absolutely not within my control.

I remarked out the calling of rebuild_tree, to eliminate any program logic related error.

As you can see in the csv file. There are two records with role_id_snr = 'GLOBAL'

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 <**** in sql trace file

But the query only returns one, you can see this in the sql trace file.

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

Attachment: Feb14.zip
(Size: 2.09KB, Downloaded 1364 times)

[Updated on: Tue, 13 February 2007 20:37]

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 Apr 14 22:44:41 EDT 2025

Total time taken to generate the page: 0.01744 seconds