I am looking for a step by step tutorial for dreamweaver mx2004 asp/vbscript. I want to create a drop down list/menu in my form and retreive the data from the database on a results page. Can someone please help me
Yes I am trying to use a recorset and I want to show a results page with the data from my database depending on what the user selects from the dropdown list.
Not hard at all. I assume you already made a recordset of what goes into the dropdown. In your recordset you'll need one parameter for the dropdown labels (shown to user), and one for values (not seen by user).
DW has the easiest implimentation for form objects - click Insert > Application Objects > Dynamic Data > Dynamic Select List, and attach your recordset to it.
Remember you'll need the dropdown menu wrapped in a form tag, with a submit button. The action attribute of the form should point to the details page, and the details page should grab the value from the dropdown list that you made for it to filter its recordset.
I wrote this short because DW is a great tool and it's pretty much as easy as that.
Comments
a little more detail goes a long way...
RE: a little more detail goes a long way...
RE: RE: a little more detail goes a long way...
DW has the easiest implimentation for form objects - click Insert > Application Objects > Dynamic Data > Dynamic Select List, and attach your recordset to it.
Remember you'll need the dropdown menu wrapped in a form tag, with a submit button. The action attribute of the form should point to the details page, and the details page should grab the value from the dropdown list that you made for it to filter its recordset.
I wrote this short because DW is a great tool and it's pretty much as easy as that.
If you are learning about form basics check out this premium article Cornerstones: DMX Forms. If you are getting familiar with forms and ASP, then maybe would benefit from reading ASP and Forms: The Request object
Hope this helped. :)article(s)
You must me logged in to write a comment.