troubleshooting Question

Update database with asp when setting option on select

Avatar of robrodp
robrodpFlag for Mexico asked on
ASPJavaScriptMicrosoft SQL Server
2 Comments1 Solution464 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
leakim971
Multitechnician
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros