Radicore Forum: How To » many to many and field names

Home » RADICORE » How To » many to many and field names

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

Re: many to many and field names [message #522 is a reply to message #521]

Thu, 04 January 2007 13:25

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

Senior Member

I avoid conventions like this because they cause more problems than they solve, just like the problem you have just encountered. See http://www.tonymarston.net/php-mysql/technicalkeys.html#wors e1 for a more detailed explanation of this problem.

Your problem is that the WHERE clause passed down from the parent form contains "id='something'" but the column name 'id' has to be translated into either 'employee_id' or 'group_id' depending on the parent form. It would be possible to obtain the name of the previous form using either the getPreviousScript() or getPreviousTask() functions, but I would strongly recommend dropping that convention and change the primary key for each table so that instead of 'id' you have '<tablename>_id' instead. This will cause fewer problems in the long run.

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

Report message to a moderator

[Message index]

		many to many and field names By: interop on Thu, 04 January 2007 11:10
		Re: many to many and field names By: AJM on Thu, 04 January 2007 13:25

Previous Topic:	displaying many to many relationships
Next Topic:	List with pre-defined search active

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Apr 21 07:25:24 EDT 2026

Total time taken to generate the page: 0.01070 seconds