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