Selected item in Combo Box from database
Sorry i forgot To define form name
Ever wanted To Get selected item In combo box (from database) when modifying the data here Is the code
we have a table called tblClientDetail where we have all details about client Like name And city,country here i'm using only city
*************database structure******
clname Text
claddress Text
fldcity Text
ASP FILE
*********modifyClient.asp*******************
<%
'first make the connection object
response.buffer=True
Set objcon=server.createobject(""adodb.connection"")
Set objRs=server.createobject(""Adodb.recordset"")
Dim getcity
strSQL=""Select fldCity from tblClientDetail ""
objRs.Open strsql,objcon,1,2
If Not objRs.EOF Then
getCity=objRS(""fldCity"")
End If
%>
<html>
<head>
<script language=""Javascript"">
/*
eg.
Function For selecting the data from the data base you can pass multiple arguments If you have
more than one combobox
Like
Function chek_imp(msg1,msg2,msg3,msg4,msg5,msg6,msg7) And pass all these In
<body onLoad=""chek_imp('<%=getCity%>','<%=getsdate%>','<%=getsmonth%>','<%=getsyr%>','<%=getedate%>','<%=getemonth%>','<%=geteyr%>','<%=getCity%>')"">
*/
Function chek_imp(msg1){
document.frmLogin.city.value=msg1
</script>
</head>
<body onLoad=""chek_imp('<%=getCity%>')"">
<form name=""frmLogin"" method=""post"" action=""modifyClient.asp"">
Select combobox:<br>
<Select Class=textboxes1 name=city>
<Option value="""" selected><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Select</font></Option>
<Option
value=Agra><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Agra</font></Option>
<Option value=Ahmedabad><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Ahmedabad</font></Option>
<Option value=Allahabad><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Allahabad</font></Option>
<Option
value=Ambala><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Ambala</font></Option>
<Option value=Amritsar><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Amritsar</font></Option>
<Option value=Aurangabad><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Aurangabad</font></Option>
<Option
value=Bangalore><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Bangalore</font></Option>
<Option
value=Bareilly><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Bareilly</font></Option>
<Option value=Baroda><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Baroda</font></Option>
<Option value=Bhopal><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Bhopal</font></Option>
<Option
value=Bhubaneshwar><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Bhubaneshwar</font></Option>
<Option
value=Chandigarh><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Chandigarh</font></Option>
<Option
value=Chennai><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Chennai</font></Option>
<Option value=Cochin><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Cochin</font></Option>
<Option value=Coimbatore><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Coimbatore</font></Option>
<Option
value=Cuttack><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Cuttack</font></Option>
<Option value=Dehradun><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Dehradun</font></Option>
<Option value=Delhi><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Delhi</font></Option>
<Option value=Erode><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Erode</font></Option>
<Option value=Faridabad><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Faridabad</font></Option>
<Option
value=Ghaziabad><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Ghaziabad</font></Option>
<Option
value=Gurgaon><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Gurgaon</font></Option>
<Option value=Guwahati><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Guwahati</font></Option>
<Option value=Gwalior><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Gwalior</font></Option>
<Option
value=Hyderabad><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Hyderabad</font></Option>
<Option value=Indore><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Indore</font></Option>
<Option value=Jaipur><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Jaipur</font></Option>
<Option
value=Jamshedpur><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Jamshedpur</font></Option>
<Option
value=Jodhpur><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Jodhpur</font></Option>
<Option value=Kanpur><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Kanpur</font></Option>
<Option value=Kochi><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Kochi</font></Option>
<Option
value=Kolkata><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Kolkata</font></Option>
<Option value=Lucknow><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Lucknow</font></Option>
<Option value=Ludhiana><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Ludhiana</font></Option>
<Option
value=Madurai><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Madurai</font></Option>
<Option
value=Mangalore><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Mangalore</font></Option>
<Option
value=Mathura><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Mathura</font></Option>
<Option value=Meerut><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Meerut</font></Option>
<Option value=Mohali><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Mohali</font></Option>
<Option
value=Mumbai><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Mumbai</font></Option>
<Option value=Mysore><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Mysore</font></Option>
<Option value=Nagpur><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Nagpur</font></Option>
<Option value=Nasik><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Nasik</font></Option>
<Option value=Noida><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Noida</font></Option>
<Option value=Ooty><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Ooty</font></Option>
<Option value=Panjim><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Panjim</font></Option>
<Option
value=Patiala><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Patiala</font></Option>
<Option value=Patna><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Patna</font></Option>
<Option value=Pondicherry><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Pondicherry</font></Option>
<Option
value=Pune><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Pune</font></Option>
<Option value=Ranchi><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Ranchi</font></Option>
<Option
value=Rourkela><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Rourkela</font></Option>
<Option value=Salem><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Salem</font></Option>
<Option value=Secunderabad><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Secunderabad</font></Option>
<Option
value=Srinagar><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Srinagar</font></Option>
<Option value=Surat><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Surat</font></Option>
<Option value=Trichy><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Trichy</font></Option>
<Option
value=Trivandrum><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Trivandrum</font></Option>
<Option
value=Udaipur><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Udaipur</font></Option>
<Option value=Vadodara><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Vadodara</font></Option>
<Option value=Varanasi><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Varanasi</font></Option>
<Option
value=Vijayawada><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Vijayawada</font></Option>
<Option
value=Visakhapatnam><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Visakhapatnam</font></Option>
<Option value=others><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Other
Indian City</font></Option>
<Option value=--><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">----------</font></Option>
<Option
value=Int_Loc><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">International
Locations</font></Option>
<Option
value=Australia><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Australia</font></Option>
<Option
value=Bahrain><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Bahrain</font></Option>
<Option value=Bangladesh><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Bangladesh</font></Option>
<Option value=Belgium><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Belgium</font></Option>
<Option value=Canada><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Canada</font></Option>
<Option value=China><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">China</font></Option>
<Option value=Dubai><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Dubai</font></Option>
<Option value=France><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">France</font></Option>
<Option value=Germany><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Germany</font></Option>
<Option value=""Hong Kong""><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Hong
Kong</font></Option>
<Option value=Indonesia><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Indonesia</font></Option>
<Option
value=Ireland><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Ireland</font></Option>
<Option value=Italy><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Italy</font></Option>
<Option value=Japan><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Japan</font></Option>
<Option value=Kenya><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Kenya</font></Option>
<Option value=Kuwait><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Kuwait</font></Option>
<Option
value=Lebanon><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Lebanon</font></Option>
<Option value=Libya><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Libya</font></Option>
<Option value=Malaysia><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Malaysia</font></Option>
<Option
value=Maldives><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Maldives</font></Option>
<Option
value=Mauritius><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Mauritius</font></Option>
<Option value=Mexico><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Mexico</font></Option>
<Option value=Nepal><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Nepal</font></Option>
<Option
value=Netherlands><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Netherlands</font></Option>
<Option value=""New Zealand""><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">New
Zealand</font></Option>
<Option value=Norway><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Norway</font></Option>
<Option
value=Omam><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Omam</font></Option>
<Option value=Pakistan><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Pakistan</font></Option>
<Option value=Russia><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Russia</font></Option>
<Option value=""Saudi Arabia""><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Saudi
Arabia</font></Option>
<Option value=Singapore><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Singapore</font></Option>
<Option
value=""South Africa""><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">South
Africa</font></Option>
<Option
value=Spain><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Spain</font></Option>
<Option value=""Sri Lanka""><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Sri
Lanka</font></Option>
<Option value=Switzerland><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Switzerland</font></Option>
<Option
value=Thailand><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Thailand</font></Option>
<Option
value=""United Arab Emirates""><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">United
Arab Emirates (UAE)</font></Option>
<Option
value=""United Kingdom""><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">United
Kingdom (UK)</font></Option>
<Option
value=""United States""><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">United
States (USA)</font></Option>
<Option
value=Zimbabwe><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Zimbabwe</font></Option>
<Option value=Other_Int><font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"">Other
International Location</font></Option>
</Select>
</form>
</body>
</html>
"
