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