Doh! Nevermind--I removed and restored the Category ID field on the Child Add and Edit forms within the IDE and somehow that reset something within the code generator--now I'm getting the PKID as the value for the dropdown, with the AltKey text in the display. I'm still stumped on the Org ID problem though, so any help would be appreciated.
REM O- > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Rey Muradaz > Sent: Monday, March 21, 2005 11:48 AM > To: [email protected] > Subject: RE: [plum] Filtered Select Follow Up (now a feature request) > > I'm having some trouble with this--I did as instructed, and > now have my CategoryID as the PK and CategoryName as the > Alternate Key in the Database element of the IDE. But when I > generate my code, the select menu uses the Alt Key values for > both the display and value of the dropdown. Any suggestions > would be greatly appreciated. > > REM O- > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On > Behalf Of Tim > > Blankenship > > Sent: Friday, March 11, 2005 7:01 AM > > To: [email protected] > > Subject: Re: [plum] Filtered Select Follow Up (now a > feature request) > > > > Well it was quite simple. Here is how to do it for others > whom might > > want to know. > > I did it throught Enterprise Manager. Just go to the table > and expand > > and select indexes. > > You probably have one made by default the references the > PK, just do a > > create like and choose the column you want referenced (TYPE > for mine). > > Sync with the db in plum and your done. Plum figures the rest out! > > Damn I love this program. > > > > > > On Thu, 10 Mar 2005 16:54:57 -0500, Jeff Fleitz > > <[EMAIL PROTECTED]> wrote: > > > Hi Tim, > > > > > > Not really a lot of magic to this. An alternate key is just a > > > character field in your table that you create a unique > index for in > > > your CASE tool or with Oracle admin tools. Just like the email > > > address in the PlumUser table is an alternate key for the > userid. > > > Integer ids (surrogate keys) don't make much sense to > > anyone in a pull down menu, so you just find some other table > > attribute/column that is unique to a row, build a unique > > index for it in Oracle and Plum should pick it up during the > > synch process. > > > > > > I know absolutely squat about Oracle, so I can't help you there. > > > > > > Jeff > > > > > > > > > Tim Blankenship wrote: > > > > Do you have an example of this? > > > > > > > > > > > > On Thu, 10 Mar 2005 16:13:24 -0500, Adam Churvis > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > >>Create a unique index. > > > >> > > > >>Respectfully, > > > >> > > > >>Adam Phillip Churvis > > > >>Member of Team Macromedia > > > >>http://www.ProductivityEnhancement.com > > > >> > > > >>Download Plum and other cool development tools, and get > advanced > > > >>intensive Master-level training: > > > >> > > > >>* C# & ASP.NET for ColdFusion Developers > > > >>* ColdFusion MX Master Class > > > >>* Advanced Development with CFMX and SQL Server 2000 > > > >> > > > >>----- Original Message ----- > > > >>From: "Tim Blankenship" <[EMAIL PROTECTED]> > > > >>To: <[email protected]> > > > >>Sent: Thursday, March 10, 2005 10:37 AM > > > >>Subject: Re: [plum] Filtered Select Follow Up (now a feature > > > >>request) > > > >> > > > >> > > > >>>I can't do this (or don't know how) to create the > > alternate key in > > > >>>Oracle. I will google it but off the top of my head I > just can't > > > >>>think of it. > > > >>> > > > >>> > > > >>>On Wed, 9 Mar 2005 11:00:51 -0600, Aaron Longnion - hotmail > > > >>><[EMAIL PROTECTED]> wrote: > > > >>> > > > >>>>You should be able to do this (at least in SQL Server 2K) by > > > >>>>adding an Alternate Key to the column you want to > > display on the > > > >>>>DB, then go to > > > >> > > > >>the > > > >> > > > >>>>IDE, sync with DB, go to the table with the display > > column in it, > > > >>>>check > > > >> > > > >>the > > > >> > > > >>>>select in the IDE called "Simple alternate key" to > make sure it > > > >>>>picked > > > >> > > > >>up > > > >> > > > >>>>your Alt Key from the DB. Then, it seems you have to > > completely > > > >>>>delete > > > >> > > > >>and > > > >> > > > >>>>recreate the CFM pages where your want the filtered > > select. Then, > > > >>>>regen your code (maybe better to rerun your setup, I'm > > not sure), > > > >>>>and this > > > >> > > > >>worked > > > >> > > > >>>>for me (after a lot of trial and error... ugh). > > > >>>> > > > >>>>Hope this helps, > > > >>>>Aaron > > > >>>> > > > >>>> > > > >>>>----- Original Message ----- > > > >>>>From: "Tim Blankenship" <[EMAIL PROTECTED]> > > > >>>>To: "Plum Email List" <[email protected]> > > > >>>>Sent: Wednesday, March 09, 2005 8:53 AM > > > >>>>Subject: [plum] Filtered Select Follow Up (now a > > feature request) > > > >>>> > > > >>>> > > > >>>>>Sorry for for being a dumbass I know to just open > the code and > > > >>>>>change the displaycolumn. > > > >>>>>Is there a way in future release of Plum to add the > ability to > > > >>>>>manipulate this in the IDE? > > > >>>>> > > > >>>>>-- > > > >>>>>Tim Blankenship > > > >>>>>[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/DiscussionListsFor > > > >>>>>m.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 > > > > > > >>>>****************************************************************** > > > >>>>**** > > > >>>> > > > >>> > > > >>> > > > >>>-- > > > >>>Tim Blankenship > > > >>>[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 > > > > > > >>>******************************************************************* > > > >>>*** > > > >>> > > > >> > > > > > > >>******************************************************************** > > > >>** 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.c > > > >>fm > > > > > > >>******************************************************************** > > > >>** > > > >> > > > > > > > > > > > > > > > > > > > > > ********************************************************************** > > > 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] > > > > > ********************************************************************** > > 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 **********************************************************************
