Radicore Forum: How To » list2 not respecting list1 key

Home » RADICORE » How To » list2 not respecting list1 key

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

Re: list2 not respecting list1 key [message #1855 is a reply to message #1854]

Sun, 16 November 2008 12:22

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

If the field name in the WHERE string which is extracted from the parent table is "location_id", but the corresponding field name in the child table is "FKlocation_id", then that is your problem. The framework assumes that fields which have the same meaning have the same name, and here they do not. You must insert custom code to manually change that entry in the WHERE string as the framework cannot do it for you.

You will find some examples of this in the MENU susbsystem - take a look inside the _cm_pre_getData() method of "mnu_nav_button_jnr.class.inc" and "mnu_nav_button_snr.class.inc" which show where the field name "task_id" is changed to either "task_id_jnr" to "task_id_snr".

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		list2 not respecting list1 key By: rgervais on Fri, 30 March 2007 09:56
		Re: list2 not respecting list1 key By: AJM on Fri, 30 March 2007 10:45
		Re: list2 not respecting list1 key By: rgervais on Fri, 30 March 2007 13:12
		Re: list2 not respecting list1 key By: AJM on Fri, 30 March 2007 13:45
		Re: list2 not respecting list1 key By: rgervais on Fri, 30 March 2007 16:33
		Re: list2 not respecting list1 key By: AJM on Fri, 30 March 2007 16:59
		Re: list2 not respecting list1 key By: rgervais on Sat, 31 March 2007 07:54
		Re: list2 not respecting list1 key By: AJM on Sat, 31 March 2007 08:22
		Re: list2 not respecting list1 key By: AJM on Sat, 31 March 2007 10:46
		Re: list2 not respecting list1 key By: rgervais on Sun, 01 April 2007 20:44
		Re: list2 not respecting list1 key By: David Lee on Sat, 15 November 2008 07:32
		Re: list2 not respecting list1 key By: AJM on Sat, 15 November 2008 09:36
		Re: list2 not respecting list1 key By: David Lee on Sun, 16 November 2008 12:02
		Re: list2 not respecting list1 key By: AJM on Sun, 16 November 2008 12:22
		Re: list2 not respecting list1 key By: AJM on Sun, 19 July 2009 06:23

Previous Topic:	Update1 problem
Next Topic:	Intranet Application

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Jul 14 03:31:21 EDT 2025

Total time taken to generate the page: 0.03147 seconds