It is giving problem on
sub secondDropDownOnChange()
this line saying "invalid character"
I don't think there is anything wrong . Do I have to make any setting change on server for accepting
Request.ServerVariables("SCRIPT_NAME"

?
Did you try running this code on your end ? Is it giving you the same error ?
I am pasting the code once again ........
<%@ Language=VBScript %>
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<script language = "vbscript">
sub ClientIDOnChange()
document.order.submit()
end sub
</script>
</head>
<body>
<form method="POST" action="<%=request.serverVariables("SCRIPT_NAME"

%>" name = "order" id= "order">
<select id="ManID" name="ManID" onchange = "document.order.submit()">
<option VALUE="ABC">ABC</option>
<option VALUE="CDF">CDF</option>
</select>
<%
manid=Request.Form("ManID"

Response.Write manid
if manid <> "" then
set cnn = Server.CreateObject("ADODB.connection"

set rs = server.CreateObject("ADODB.recordset"

strcnn= "PROVIDER=SqlOLEDB.1;persist securityinfo = false ;initial catalog = XYZ;USER Id=userID;Password=passwd;Data source = SERVER "
cnn.open strcnn
dim sqlstmt
sqlstmt ="select cl_id from Tblclmaster where man_id ='" &manid &"'"
rs.open sqlstmt,cnn,adopendynamic,adlockoptimistic,adcmdtext %>
<select id="clientID" name="ClientID" MAXLENGTH="20" >
<%do until rs.eof%>
<option value= "<%Response.Write rs("cl_id"

%>" >
<% Response.Write rs("cl_id"

rs.MoveNext
loop
set rs = nothing %>
<option value="" selected>
</select>
<%end if%>
</form>
</body>
</html>
I don't know whats going wrong..........
Thanks