HELP....
I am having two list boxes in the ASP page which displays data from the database filed.
One is for selecting the category (Default-ALL). And another one for listing items in the selected category.
By default I have listed all the items in the itemlist box. If the user selects specific category it should display the item list for the specific category. If possible give some idea.

Thanks in advance.

Umm do Request.Form("element") to get the value?

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

<FORM Method="POST" Action="showissue.asp">
<P>Category
<INPUT id=radio1 type=radio name=cat value="CA" checked onClick="showCat()">All
<INPUT type=radio name=cat value="CS" onClick="showCat()">Specific<Br>
Select Category
<SELECT id=catlist style="WIDTH: 164px" name=catlist disabled>
<OPTION selected>Stationery</OPTION>
<OPTION>Sanitary</OPTION>
<OPTION>Perishable</OPTION>
</SELECT></P>
<P>Item
<INPUT type=radio name="item" value="IA" CHECKED onClick="showItem()">All
<INPUT type=radio name="item" value="IS" onClick="showItem()">Specific<Br>
Select Item
<%
Set objCon=Server.CreateObject("ADODB.Connection")
objcon.open "stores"

Set rsItem=Server.CreateObject("ADODB.Recordset")
rsItem.open "Select Icode,Name From Item Order By Name",objCon
%>
<SELECT style="WIDTH: 281px" name="itemlist" SIZE="1" disabled>
<%
Do While Not rsItem.EOF
Response.Write "<OPTION VALUE="&rsItem("Icode")&">"&rsItem("Name")&"</OPTION>"
rsItem.MoveNext
Loop

rsItem.Close
Set rsItem=nothing
%>
</SELECT></P>
</FORM>

This is the typical example of where AJAX is useful.

If I understand your requirement, what you want to do is populate the Item List with a different set of values based on what is selected in the category list.

There are at least three ways to do this:
1 - Make a post of the page - this requires a "full" round-trip to the server and is the worst solution of the three I cover here.
2 - Hold a client side copy of the entire list in an array in Javascript or in some XML block in the html, and use that array to repopulate the Item List dynamically. This is not too bad as long as the item list is more or less short.
3 - Use AJAX to make a call to get the filtered list you need and dynamically reset the Item List with it.

Solutions 2 and 3 require manipulating the DOM of your HTML document dynamically using Javascript (or any other supported scripting language... but of course, Javascript is the only realistic choice).

There are other solutions such as data islands, and I am sure there are soluctions I don't know about or have never considered.

AJAX is very popular right now, but it has actually been around in its current form since about 1999 when Microsoft introduced the XMLHTTPRequest object. If you aren't currently using it at all, then it would probably be good for you to find out about it, and see if it fits your need. I have some applications with very complex forms and I use the AJAX model to keep the users experience as clean as possible. The response time for retrieving the filtered lists are usually very fast and usually the users don't notice any delay at all. Compared to solution 1 (the full post back), the experience is superior in all ways. The only caveat is that Javascript must be enabled in the browser. This generally isn't a problem for your typical user, but some people shut off Javascript. Additionally, there are some browser compatibility issues that you have to work through.

You can search about on the web for AJAX and find numerous examples or tutorials. It is the way to go.

Here is the wiki entry on it: http://en.wikipedia.org/wiki/Ajax_%28programming%29

Woody Z http://www.learntoprogramnow.com