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?
