I just
tested it and it works. Although it seems you must use the
<cf_primaryKey> tag and it also seems like if you do you might not be able
to display the primary key column. It was throwing a duplicate alias
error, I eliminated the primary key from the display list and then it
worked. Also, it seems the table attribute is needed (required) but it is
only used for the add link?
Mark
-----Original Message-----I would think so.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Tim Blankenship
Sent: Wednesday, August 24, 2005 12:57 PM
To: [email protected]
Subject: [Norton AntiSpam] Re: [plum] displaylist on non related table
On 8/24/05, Mark Fuqua <[EMAIL PROTECTED]> wrote:Hey there,<cf_displayList> does have a query attribute. My question would be: If you supply a custom query to the tag, can you then use the field names with <cf_DisplayColumnInList>?Mark-----Original Message-----Not sure if we are on the same page Jeff.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tim Blankenship
Sent: Wednesday, August 24, 2005 12:36 PM
To: [email protected]
Subject: Re: [plum] displaylist on non related table
I have a list like follows
SN NAME
123 pooter
I want to add another field like TYPE
SN NAME TYPE
123 pooter server
SN and NAME are from table1
TYPE is from table2
They are not related(parent/child) but table1 and table2 have the primary key of SN
On 8/24/05, Jeff Fleitz <[EMAIL PROTECTED]> wrote:Hi Tim,
If I understand you correctly, try using something like the following using a closing cf_DisplayListLinks tag, same as
what you would do for a normal drill-up/down (watch the line wrap). Make sure that the AddFormAction page returns you
to this list using the redirect attribute in the cf_InsertRecord tag.
[<a
href="">Add
Form</a>]
</cf_DisplayListLinks>
Jeff
Tim Blankenship wrote:
> Hello all, I have a list that I need to add a entry that is populated
> from a non related table but does share a common PK. What is the best
> approach for this? Thanks
>
> --
> Tim Blankenship
> [EMAIL PROTECTED] <mailto: [EMAIL PROTECTED] >
**********************************************************************
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
**********************************************************************
--
Tim Blankenship
[EMAIL PROTECTED]
--
Tim Blankenship
[EMAIL PROTECTED]
