The documentation kind of leads you to believe that the tag acts as a FilteredSelectMenu with the extra functionality of being able to add new items on the fly, but it won't work that way in it's current form. I found this out many months ago when I was trying to use it in the manner you are. Some short term spelunking in the tag suggested it cannot handle these type of value updates at this time.
I find it is great for self-referencing lookups of text fields within the same table, or to single column lookup tables with where the primary key and alternate keys are the same (a code table with only a text 'code' field, for example). In cases where I have to use it with a list of pre-existing values, I will create a lookup table with one field to store the value, and some maintenance forms to handle it in admin, so that values can be pruned when necessary.
On 11/18/05, Anne Girardeau <[EMAIL PROTECTED]> wrote:
Jeff,Here's the code:<cfmodule template="#Request.adminLayout#/Header.cfm" pageType="Database"><cf_DisplayEditForm table="Model" label="Edit a Model" action="" displayALinkToThisList="ModelList.cfm ">
<cf_PrimaryKey primaryKeyColumn="modelID" primaryKeyType="integer" value="#URL.modelID#">
<cf_JoinToParent table="Make" primaryKeyColumn="makeID" foreignKeyColumn="makeID" optionality="Optional">
<cf_DisplayComboSelect
column = "make"
lookupTable = "Make"
lookupTableValueColumn = "makeID"
lookupTableDisplayColumn= "make"
label = "Make"
valueColumnType = "integer"
displayColumnType = "varchar(50)"
size = "20"
maxLength = "35"
otherItemLabel = "Other:"
fieldSeparator = "<br>"
required = "Yes"
>
<cf_DisplayTextInput column="model" label="Model" type="varchar(255)" required="No" size="40"><cf_DisplaySubmitButton buttonText="Save">
</cf_DisplayEditForm><cfmodule template="#Request.adminLayout#/Footer.cfm">To: [email protected]
From: Jeff Fleitz < [EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
Date: 11/18/2005 11:23AM
Subject: Re: [plum] DisplayComboSelect on Edit Form
Hi Anne,
I do it all the time. Why don't you post the tag code so that we can take a look at it.
On 11/18/05, Anne Girardeau < [EMAIL PROTECTED] "_blank" > wrote:Is there any way to use the cf_DisplayComboSelect tag on an edit form? I've tried doing this on my own but get the following error:Too few parameters. Expected 1.Any help with this would be greatly appreciated.Thanks,--Anne
Confidentiality Notice: This E-Mail transmission may contain confidential or legally privileged information that is intended only for the individual or entity named in the E-Mail address. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or reliance upon the contents of this E-Mail is strictly prohibited. If you have received this E-Mail transmission in error, please reply to the sender, so arrangements can be made for proper delivery, and then delete the message from your system. Thank you.
********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm "_blank" **********************************************************************
--
v/r,
Jeff Fleitz
Confidentiality Notice: This E-Mail transmission may contain confidential or legally privileged information that is intended only for the individual or entity named in the E-Mail address. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or reliance upon the contents of this E-Mail is strictly prohibited. If you have received this E-Mail transmission in error, please reply to the sender, so arrangements can be made for proper delivery, and then delete the message from your system. Thank you.
********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
--
v/r,
Jeff Fleitz
