I am not seeing this behavior. Can you send your copy of cf_DisplayFilteredSelect to [EMAIL PROTECTED]
Dave ----- Original Message ----- From: "Jeff Fleitz" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, February 01, 2005 2:37 PM Subject: Re: [plum] Fitered Select Revisited > I take this back. The whereClauseExtension is acting properly, but if you set a default attribute, you get the FS menu, > even though only one record is returned. > > > Jeff Fleitz wrote: > > This one appears to be broken still. 1 row being returned still results > > in a filtered select menu instead of a standard select menu. > > > > Jeff > > > > > > Adam Churvis wrote: > > > >> Will be fixed in the final release. > >> > >> 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: "Jeff Fleitz" <[EMAIL PROTECTED]> > >> To: <[email protected]> > >> Sent: Thursday, January 27, 2005 2:56 PM > >> Subject: Re: [plum] Fitered Select Revisited > >> > >> > >> > >>> Also, even though the whereClauseExtension only returns 1 record, I am > >> > >> > >> still presented with a filtered select menu > >> > >>> instead of a select menu (defaults to 30 rows according to the docs). > >>> If I > >> > >> > >> add a number higher than the total row count > >> > >>> in the table in the maximumnumberofoptions attribute, I get a select > >>> menu. > >>> > >>> I thought this was fixed in the release notes, but maybe you were > >> > >> > >> referring to something else? > >> > >>> Jeff > >>> > >>> > >>> > >>> Jeff Fleitz wrote: > >>> > >>>> I am going back into some older, simple forms that are using filtered > >>>> selects and I am still having some problems with RC2, even though the > >>>> release notes say you fixed this. The scenario is using a > >>>> whereClauseExtension in a Filtered Select menu. I drill down from > >>>> OfficeList -> OfficePhoneList to add one or more phone numbers for the > >>>> office. I want the filtered select to default to the Office I just > >>>> drilled down from, so I add a whereClauseExtension to the filtered > >>>> select tag as follows: > >>>> > >>>> whereclauseextension="Office.OfficeID = #Session.OfficeID#" > >>>> > >>>> This creates a result set of zero because the whereClauseExtension > >>>> always forces the select statement to evaluate to false and return zero > >>>> records. > >>>> > >>>> The filtered select query without the whereClauseExtension looks like: > >>>> > >>>> SELECT Office.OfficeID > >>>> FROM Office > >>>> WHERE 0 > 1 > >>>> ORDER BY Office.OfficeID > >>>> > >>>> > >>>> With it, it looks like: > >>>> > >>>> SELECT Office.OfficeID > >>>> FROM Office > >>>> WHERE 0 > 1 AND Office.OfficeID = 662 > >>>> ORDER BY Office.OfficeID > >>>> > >>>> > >>>> That is always going to evalute to zero, isn't it? Should be 1 > 0? I > >>>> changed line 160 in the DiplayFilteredSelect tag to '1 > 0' and I get > >>>> back the one record I am looking for. > >>>> > >>>> Jeff > >>>> > >>>> ********************************************************************** > >>>> 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 > >> ********************************************************************** > >> > >> > > > > ********************************************************************** > > 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 **********************************************************************
