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?
