Re: different results in queries [message #630 is a reply to message #629] |
Tue, 13 February 2007 20:36 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to previous message](/theme/default/images/down.png) |
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 1240 times)
[Updated on: Tue, 13 February 2007 20:37] Report message to a moderator
|
|
|