Update database with asp when setting option on select

robrodp
robrodp used Ask the Experts™
on
I have a script that has 2 multiple selects

<select multiple>
</select>

When the form is submitted it runs a script depending on the values of the select options selected.

Now.

The select options are created accesing a database.

The first one is quite simple. Open a table, scan the values for the <select multiple></select>

The tricky part is:

The second select scans a recordset  but the sql query depends on the values set on the first select.

Say the first select has students and the second has subjects, we want to select from all the students (one or more) in the first <select name="students" multiple></select> and in the second open a record set like:

select * from subjects,students where students.ok=1 (assuming the students table has an ok field which is set in the first select)

What is required is that when a value is set (on or off) in the first select the table of students is updated with ok=1 (is set on) or ok=0 (if set off).

I realize that javascript will run a js function with the onchange event. But I have no Idea if how to change the databse values (first select. update students set ok=1 where...)

Of course the whole purpose is to not run the form in order to update the vaues and then populate the second <select name="subjects" multiple></select>.

I need it to be a one step script.

The two <select></select> are in a form that when submitted it runs a script that uses the data from the values set in the form.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Multitechnician
Top Expert 2014
Commented:
You're looking for cascading dropdown, a similar question here :
http://www.experts-exchange.com/Programming/Languages/Scripting/AJAX/Q_26498993.html

basicaly you need to create a script returning ONLY the result, depending the format you choose you will have more work to do.

for example if we call : yourpage.asp?ok=1
your script need to return result for ok=1 :
in HTML :
<option value="foo1">foo1</option>
<option value="foo2">foo2</option>
<option value="foo3">foo3</option>

in string CSV :
foo1,foo2,foo3

in JSON format:
[{"foo1":"foo1"},{"foo2":"foo2"},{"foo3":"foo3"}]
robrodpProgrammer

Author

Commented:
Exaclty what I was looking for Thz

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial