5 Replies Latest reply on Sep 12, 2008 11:38 AM by Newsgroup_User

    Display Filtering

    James_PT Level 1
      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?

        • 1. Re: Display Filtering
          Level 7
          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?
          >
          >
          >

          • 2. Re: Display Filtering
            James_PT Level 1
            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?
            • 3. Re: Display Filtering
              Level 7
              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?
              >

              • 4. Re: Display Filtering
                James_PT Level 1
                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?
                • 5. Re: Display Filtering
                  Level 7
                  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?
                  >