Display query results in Combobox2 based on the selected value of Combobox1

The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Here, I am not able to get the value of 'txtrt' to rtyp. request.Form is working in other parts of the page. Why this is happening. how can get the value of 'txtrt', so that I can retrieve values from database based on that. Please help. I am playing around the problem for the last 2days. Is there is any alternate way to do this. I can get the value of txtrt using vb script. But,how can i pass that value to server side so that i can retrieve values from database

Display query results in Combobox2 based on the selected value of Combobox1

Hi,
I have two comboboxes,say cb1 and cb2. cb1 has 3 values,say dept1,dept2,dept3. When the value of cb1 changes,I want to retrieve values from oracle database based on the value of dept1, i.e,if I select dept1,i need to get 'select name from table1 where dept="dept1". If the selected value was dept2,then the query should be like this,'select name from table1 where dept="dept2".Then,cb2 should display all the names resulting from query.How can I do this in an asp page. Pls help. I am very new to classic asp and vb.