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