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