View Full Version : Newbie Needs Help

05-02-2006, 10:07 AM
I'm using DW 8. Is it possible to use data entered into form fields prior to doing a submit? I have a frame that provides the user with some dropdowns that are created via an SQL query. I want to build another SQL query based on data selected in those dropdowns (in another frame). I don't know if I can use those dropdown fields in the SQL statement without doing a submit to the server, and if so I need to know how to reference the fields in the statement.

Any help on this is greatly appreciated.

05-05-2006, 10:47 AM
I'm pretty new myself so not sure if my solution is best, but using DW8 you can use the 'behavior' option under the 'window' menu and set the form to autosubmit when the user clicks or changes the dropdown. So enter onclick or onchange in the first colum in behaviours and form.submit() in the second. Remembe then to request the dropdown value in the Initial Value field of the dropdown box so you don't lose t he users input: <%request.form("dropdownname")%>