Re: [dbforms] ConfTableData Tag

[Marco Stefani]

Title: Nachricht

Hi, Maybe the bookstore example has not a right structure... I'll try to clarify the problem.   The 2 related tables are very simple:   Component             (component_code,    component_parent,     description,     language,     company) Component_parent  (component_code,    description,     language,    company)   In the insert and update page of Component record I would like to select the Component_parent using a select html tag:               <db:select fieldName="COMPONENT_PARENT">                 <db:confTableData                 filter="LANGUAGE='myLanguage',COMPANY='myCompany'"                 name="myQuery"                 foreignTable="COMPONENT_PARENT"                 visibleFields="DESCRIPTION"                 storeField="COMPONENT_PARENT"                 />             </db:select>   I obtain a select html tag like this:   <select name="[EMAIL PROTECTED]">     <option value="companyName">, componentParent1, I, 1</option>     <option value="companyName">, componentParent2, I, 2</option> </select>   As you can see in the option html tag value and label are incorrect: - the value should be 1 or 2 (storeField attribute) - the label should be only componentParent1 or componentParent2 (visibleFields attribute)   Should I use the queryData tag instead?   Thanks.   Marco Stefani   ----- Original Message ----- From: Henner Kollmann To: 'Marco Stefani' Cc: [EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 11:18 AM Subject: AW: [dbforms] ConfTableData Tag Could you build a small testpage based on the bookstore example to reproduce the error?   Thanks Henner -----Urspr�ngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Marco Stefani Gesendet: Dienstag, 18. Mai 2004 10:57 An: [EMAIL PROTECTED] Betreff: [dbforms] ConfTableData Tag Hi, I want to show a select html tag extracting some descriptions from a related table filtering results on some fields. It seems that ConfTableData could be the right solution but  maybe it does not use correctly the attribute "VisibleFields": from a first analysis of the code I suppose that the malfunction is due to the selection of all table fields instead of the correct field set: storeField, visibleField(s).   Is there any patch for the problem or any other solution?   Thanks in advance.   Stefani Marco