Yep, Filtered Select searches in Oracle would indeed be case-sensitive, because Oracle itself is case-sensitive. I've added this issue to the bug list, but in the meantime, you can modify cf_DisplayFilteredSelect to perform a UCase() on both the database value and the incoming form value as part of the comparison. This will eliminate case problems entirely.
HTH, Dave ----- Original Message ----- From: "Tim Blankenship" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, March 28, 2005 11:58 AM Subject: Re: [plum] Filtered select with over 50 > Definately case specific for me. > > > On Fri, 25 Mar 2005 21:52:23 -0600, Tim Blankenship > <[EMAIL PROTECTED]> wrote: > > Yeah i found the setting in the cfc 2 seconds after I sent the message > > out. I will check Monday but I am pretty sure it was case sensitive. > > > > > > On Fri, 25 Mar 2005 17:42:33 -0500, Adam Churvis > > <[EMAIL PROTECTED]> wrote: > > > You're thinking about the maximumNumberOfOptions attribute of the > > > DisplayFilteredSelect custom tag. If there are more than that number of > > > total records in the target table, a filter field appears to the left of the > > > select menu. > > > > > > The search should be case-insensitive already. > > > > > > 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: "Plum Email List" <[email protected]> > > > Sent: Friday, March 25, 2005 4:57 PM > > > Subject: [plum] Filtered select with over 50 > > > > > > > So when you have a filtered select with more than 50 or whatever the > > > > exact number is, a text box is displayed next to it to narrow the > > > > results. Is there a way to increase/decrease the default limit and is > > > > there a way to make the search non case sensitive? Thanks > > > > -- > > > > 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] > > > > > -- > 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 **********************************************************************
