Update database with asp when setting option on select

Posted on 2014-08-10
Last Modified: 2014-08-10
I have a script that has 2 multiple selects

<select multiple>

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


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.
Question by:robrodp
    LVL 81

    Accepted Solution

    You're looking for cascading dropdown, a similar question here :

    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 :

    in JSON format:

    Author Closing Comment

    Exaclty what I was looking for Thz

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now