Thanks Jeff, Very good solution.
My solution was adding the alias attribute to the JoinToParent and displayViewForm custom tags. I got it working nice, but I think I like the view idea much better. This way I dont have to update all of the custom tags needed to implement it. John -----Original Message----- From: Jeff Fleitz [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 2:18 PM To: [email protected] Subject: Re: [plum] Multiple Joins to the same table Hi John, You are going to have to create a view (sql) for two of the joins. Plum will not let you alias tables at this time. So create a view and use the view reference in place of the table in the Join2Parent, e.g., <cf_JoinToParent primaryKeyColumn="companyLocationID" table="vwCustomer" foreignKey="customerID"> Jeff John Stanley wrote: > Durr, > I guess I needed to finish my original question. How do I alias the > same table joined multiple times in a view form? > > -----Original Message----- > From: John Stanley > Sent: Monday, August 29, 2005 1:58 PM > To: '[email protected]' > Subject: [plum] Multiple Joins to the same table > > > All, > I am working with a view form that looks like: > > <cf_DisplayViewForm table="shipmentCargo" > displayALinkToThisList="No" label=""> > <cf_PrimaryKey primaryKeyColumn="shipmentID" > primaryKeyType="integer" > value="#evaluate('#Application.persistentScope#.shipmentID')#"> > <cf_JoinToParent primarykeycolumn="companyLocationID" > table="companyLocation" foreignkeycolumn="customerID" > optionality="Mandatory"> > <cf_JoinToParent primarykeycolumn="companyLocationID" > table="companyLocation" foreignkeycolumn="shipperID" optionality="Optional"> > <cf_DisplayColumnOnForm column="name" > table="companyLocation" label="Customer" type="varchar(50)" renderHtml="No"> > <cf_DisplayColumnOnForm column="name" > table="companyLocation" label="Shipper" renderHtml="No"> > </cf_DisplayViewForm> > > Because my shipmentCargo table design is like this > > column type fk > nullable > ____________________________________________________________________ > shipmentID int shipment.shipmentID NO > customerID int companyLocation.companyLocationID NO > shipperID int companyLocation.companyLocationID Yes > > It doesnt look, to me, like the JoinToParent can handle this. Has anyone > else run into this? > > I have a solution for this, but before I go hog wild on implementing it, I > want to make sure I didnt overlook anything. > > Thanks, john > > > ********************************************************************** > 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 > ********************************************************************** > > ********************************************************************** > 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 > ********************************************************************** > > ********************************************************************** 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 ********************************************************************** ********************************************************************** 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 **********************************************************************
