RE: [plum] NumberOfBrainCellsDroppingQuicklyPleaseHelp

Mark Fuqua Sun, 01 May 2005 18:28:20 -0400

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.

Use of this software is persuant to the terms of the End User License Agreement
at http://www.productivityenhancement.com/plum/SoftwareLicenseAgreement.cfm

Development Team:
Adam Churvis ([EMAIL PROTECTED])
David Churvis ([EMAIL PROTECTED])
--->

<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>

Thanks for your time.

Mark Fuqua

-----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

Hey guys,

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?

Thanks a lot,

Mark Fuqua

RE: [plum] NumberOfBrainCellsDroppingQuicklyPleaseHelp

Reply via email to