?
Solved

Dreamweaver Dynamic Data Menus

Posted on 2009-04-16
5
Medium Priority
?
482 Views
Last Modified: 2012-05-06
I have a simple access database with a table that contains the following type of data for organizing printer drivers

Model        OS        DriverType     File
Model1       XP        PCL5e            [html string to file location]
Model1       XP        PCL6              [html string to file location]
Model1       2003     PCL5e           [html string to file location]
Model2       2003     PCL5e           [html string to file location]
Model2       XP         PCL6             [html string to file location]
I am trying to use Dynamic Menus in Dreamweaver to display data conditionally i.e.
List/Menu  to select Model, Then I would like the Next Box [OS] to display only the OS listed for the Model Selected (and so on with the Driver and ultimately the file location.
So a perfect result would be: Select Model1 in List/Menu then when I click on the List/Menu for OS it only shows the OS versions available for that Model, then when that field is populated, the next List/menu [DriverType] displays only the drivers available for that Model and OS combination.  Once all of the data is available I would send it to a results page in a Dynamic Table to display the results.  Now here is the kicker, I would like to make the menu system such that if they only entered the model and click submit it will show ALL available drivers for that model.  I would like this to apply for any of the 3 List/Menu items so that if they click submit it would ignore unselected data and return results for the data selected.
So: If the user just selected Model1 and XP it would return
Model1       XP        PCL5e            [html string to file location]
Model1       XP        PCL6              [html string to file location]

If they just selected Model1 it would return:
Model1       XP        PCL5e            [html string to file location]
Model1       XP        PCL6              [html string to file location]
Model1       2003     PCL5e           [html string to file location]

If they selected Model1 and DriverType PCL5e it would return
Model1       XP        PCL5e            [html string to file location]
Model1       2003     PCL5e           [html string to file location]

If they selected just DriverType PCL5e it would return
Model1       XP        PCL5e            [html string to file location]
Model1       2003     PCL5e           [html string to file location]
Model2       2003     PCL5e           [html string to file location]

I am not a hand coder, I am a mid level Dreamweaver user and I let Dreamweaver do the code for me.  Thanks in advance for your help!
0
Comment
Question by:kgadams
  • 3
  • 2
5 Comments
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 24160216
Hi kgadams,

Do you want all of this to occur on the same page or are you willing to pass data from page to page?
0
 

Author Comment

by:kgadams
ID: 24160482
jason1178
I would like the criteria selection portion to all occur on one page, but it would be fine to have the results posted to another page.
0
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 1500 total points
ID: 24160681
You cannot easily do that with the DW base behaviors.  In order to have one dynamic list filter another, you would need to submit the form with list one and then unhide list two using a recordset that gets built from the selection in list one and then unhide list three based on the second submission in list two.

Without purchasing an add-one, this is what you would do.

1) Create all three recordsets needed, but set recordsets two and three to filter on a URL variable from list one and two (respectively).

2) Use the DW Show/Hide Region behavior to hide lists two and three if their recordsets are blank.

3) Set the form's action to GET.  So when the form is submitted, the URL would appear:

page.asp?model=Model1

Make sure list one is set to reselect the item submitted (set its dynamic value to equal the URL parameter model)

4) Now, recordset 2 should be filtering on URL parameter "model".   It should now appear with the proper choices.  Select and submit again.  URL should now show:

page.asp?model=Model1&os=XP

Make sure list two is set to reselect the item submitted (set its dynamic value to equal the URL parameter os)

5) List three should now appear...etc etc

At the end, you will have a URL that can be used to filter a new recordset to display the correct driver or send it to a new page for additional processing.

----------------

The EASIER (but more expensive) option would be to find an extension that allows you to build "dependent drop downs"  I know that Web Assist makes one but I don't know if it works with ASP or not. There are others out there or you can Google for it and build this outside of the DW wizard framework.  Dependent Drop Downs use javascript (AJAX and regular) to handle the postbacks and filter the list as the user goes along.
0
 

Author Closing Comment

by:kgadams
ID: 31571040
Thank you!
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 24171821
kgadams,

Why the B grade?
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to writing scripts for a Client/Server computing environment it is essential to consider some way of enabling the authentication functionality within a script. This sort of consideration mainly comes into the picture when we are dealin…
Introduction During my participation as a VBScript contributor at Experts Exchange, one of the most common questions I come across is this: "I have a script that runs against only one computer. How can I make it run against a list of computers in …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month15 days, 14 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question