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

different results in queries [message #624]

Mon, 12 February 2007 19:44

stephenboey
Messages: 54
Registered: January 2007

Member

Was trying to call mysql_query, mysql_fetch_array in _cm_post_updateRecord

Can this be done? Seems like calling those does not give me any results or error messages.

I went back to mysql functions because radicore does not give me the correct results. Attached is a script to implement Van Tulder's Tree http://www.sitepoint.com/print/hierarchical-data-database.

One version is using radicore and the other using his script.

Test data:
role_id role_id_snr lft rgt
GLOBAL NULL 1 10
TESTING GLOBAL 2 9
TESTING2 TESTING 3 8
TESTING3 TESTING2 4 7
TESTING4 TESTING3 5 6

Test Scenerio (Reparent TESTING2 to GLOBAL)
role_id role_id_snr lft rgt
GLOBAL NULL 1 10
TESTING GLOBAL 2 3
TESTING2 TESTING 4 9
TESTING3 TESTING2 5 8
TESTING4 TESTING3 6 7

Attachment: Script.txt
(Size: 2.07KB, Downloaded 970 times)

[Updated on: Mon, 12 February 2007 20:24]

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: Fri Jul 11 16:19:12 EDT 2025

Total time taken to generate the page: 0.09863 seconds