Display Filtering

Sure. You could either do it with a Spry dataset (that would be done client
side - and don't ask me how!), or by having an onchange event on the
list/menu <select> tag that submits the form to the same page. Have server
scripting in the head that parses out the selected value and uses that as a
filter in the SELECT statement.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"DreamerJim" <webforumsuser@macromedia.com> wrote in message
news:gae7k4$56p$1@forums.macromedia.com...
>I would like to place a drop down list box (menu) above a table that
>displays a
> few values (e.g., Open, Closed, etc.), so that when a user selects one of
> the
> values, the associated records in the table are filtered (only open, only
> closed, or all). I've tried doing this with a column variable in the SQL
> record select but can't quite seem to get it to work.
>
> Anyone done this?
>
>
>

You have a status field in the database, right? You filter on that field.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"DreamerJim" <webforumsuser@macromedia.com> wrote in message
news:gae9gl$75d$1@forums.macromedia.com...
> but what value would you set the filter to in order to get all the records
> again (options = Open, 'O', Closed 'C', or All???)
> I can pass the 'O' for open, but for all? Sounds like it may take coding
> to
> remove that portion of the Where clause when not needed?
>

In the case of "all" you would not add the WHERE clause to the SELECT
statement. Alternatively you could just use "%" I believe.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"DreamerJim" <webforumsuser@macromedia.com> wrote in message
news:gaechr$afj$1@forums.macromedia.com...
> Yes, I have a status field with an 'O' for Open and a 'C' for Closed, a
> 'P' for
> Pending, etc. I can filter on one of the values, but what happens when a
> user
> wants them all? For example, they first pick 'Closed', then they want
> them
> all. Selecting an 'All' option from the list is ok, but what value would
> be
> set in the parameter to essentially nullify the filtering effect and get
> all
> rows again?
>