Hi
Mark,
The variable
ParentData is CFset in the custom tag for DisplayFilteredSelect
or in DisplayAddForm. You may have confused the issue (what the custom tag is
looking for…) by changing the Primary Key.
Unfortunately—as far
as giving you the magic answer—I am still somewhat of a novice with respect to
Plum and its inner
workings. I’ve only just started on my first Plum project and right
now am working on integrating my designer’s layout with the
Plum
framework.
This may be a
question best answered by Adam or David. They have been teaching the
CFMX Master class this last week and I’m told will be back at the helm on
Monday, May 2nd. Hopefully Adam can reply to you
then.
Best of luck—sorry I
couldn’t be more help.
Dan
Kaufman
-----Original
Message-----
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Fuqua
Sent: Sunday, May 01, 2005 6:31
PM
To:
[email protected]
Subject: RE: [plum]
NumberOfBrainCellsDroppingQuicklyPleaseHelp
Thanks
Dan for the quick response. I could not figure out how
to set an alternate key or a candidate key in Access2000 so I just changed
my primary key to a field that would work as a primary and also be
unique. I guess that is pretty redundant. I guess what I am trying
to say is that I designated a primary key that will also be meaningful as a
display.
I know I
am missing something here. Everything about Plum is intuitive, easy and
concise. What I want to do is simple in CF...have a <cfselect>
which I read somewhere is what <cf_displayFilteredSelect>
becomes when submitted. So...what am I missing?
Here is
the code for the page...(I put three asterisks beside the offending
line.)
The
error Message I am getting is "Variable PARENTDATA is
undefined."
<!---
This code
is Copyright (c) 2004 by Productivity Enhancement, Inc.
All Rights
Reserved.
<cfmodule
template="#Request.adminLayout#/Header.cfm"
pageType="Database">
<cf_DisplayList
table="FixedEstimateItems" rowsPerPage="50" label="Fixed Estimate Items"
displayALinkToThisSearchForm="FixedEstimateItemsSearchForm.cfm">
<cf_PrimaryKey
primaryKeyColumn="FixedEstimateItemId"
primaryKeyType="integer">
<cf_DisplaySortOrderMenu>
<cf_DisplaySortOrderOption
displayText="Fixed Estimate Item Id"
sortOrder="FixedEstimateItems.FixedEstimateItemId
ASC">
</cf_DisplaySortOrderMenu>
<cf_DisplayDeleteCheckboxInList>
*** <cf_DisplayFilteredSelect
parentTable="FinishTypes" primaryKey="ShortDescription" primaryKeyType="text"
foreignKey="FinishType" displayColumn="shortDescription" required="Yes"
label="Finish Type" maximumNumberOfOptions="30">
<cf_DisplayColumnInList column="Description" label="Description"
type="varchar(100)">
<cf_DisplayColumnInList
column="FinishType" label="Finish Type" align="right"
type="integer">
<cf_DisplayColumnInList
column="FixedEstimateItemId" label="Fixed Estimate Item Id" align="right"
type="integer">
<cf_DisplayColumnInList column="ItemName"
label="Item Name" type="varchar(50)">
<cf_DisplayColumnInList
column="ItemType" label="Item Type" align="right"
type="integer">
<cf_DisplayListLinks
add="FixedEstimateItemsAddForm.cfm" view="FixedEstimateItemsViewForm.cfm"
edit="FixedEstimateItemsEditForm.cfm"
delete="FixedEstimateItemsDeleteForm.cfm">
</cf_DisplayList>
<cfmodule
template="#Request.adminLayout#/Footer.cfm">
-----Original
Message-----
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Dan
Sent: Sunday, May 01, 2005 5:23
PM
To:
[email protected]
Subject: RE: [plum]
NumberOfBrainCellsDroppingQuicklyPleaseHelp
A
Primary Key IS designated in your _db Table.
An Alternate Key is
also referred to as a
Candidate
key; this is a key
that uniquely identifies rows in a table. It could potentially serve as the
primary key. There can be more than one candidate key and a candidate key
may be composed of more than one column.
For
example, if the Contact_table contained columns: ContactID, ContactName,
EmailAddress, etc. You would designate in the table ContactID as the
PrimaryKey. Now, a key, any key, must uniquely identify a row, so
ContactName would be a bad choice as an Alternate Key because you could have
two, or more, contacts name “Mark”, but pretty much you would never
have two identical email addresses, so choosing EmailAddress as an Alternate
Key would work.
Alternate Keys can
also be two or more columns. You could designate ContactName + ContactPhone
as an Alternate Key. You might have two records for Mark, but not for
Mark + 800-770-1234.
By The
Way (BTW) your best friend is Google. As the incredible Dave Watts (at Fig
Leaf Software) once said: “It’s not how smart you are, it’s how fast can you
Google.”
Hope
this helps,
Dan
Kaufman
-----Original
Message-----
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Fuqua
Sent: Sunday, May 01, 2005 4:59
PM
To:
[email protected]
Subject: [plum]
NumberOfBrainCellsDroppingQuicklyPleaseHelp
I'm
losing my mind. Considering how small it is, this is not good.
Please help. What is an alternate key. I have done searches
everywhere. Can not find a good concise answer. I am trying to
do a simple filtered select. The documentation says that the display
column must be a key, most likely an alternate key.
"displayColumn is the name of the
column to display in the filtered select menu. Must be a key column; most
likely this will be an alternate key column. Defaults to the value of
primaryKey."
What
do they mean by alternate key and how can I set one in
Access2000?
