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