Previous Article
Galleriffic with ASP Classic and SQL Server 2005 Backened (or) Access Database
Populate triple drop down list from database using Ajax and Classic ASP
Next Article
ASP Classic Lessons 1 - 4
Coding Article #: 24 - Published On: September 09, 2011 @ 20:05:04 PM - Last Updated on: July 13, 2012
This article has been Favorited 44 times
Join today, and add this to your favorites.
Coding Source - Share on MySpace Coding Source - Share With Facebook Coding Source - Share on Twitter Coding Source - Share on Reddit Coding Source - Share on Digg It Coding Source - Share on Stumble Upon It Coding Source - Share on Delicious
Share With Friends (Updated 6-8-2010)

Supported Files
File Download:
carrzkiss_081232triple.zip
File Size: 18.35 KB
Unzip with
Download winzip today!(OR)
Screenshot of Source Code
Coding Source - Populate triple drop down list from database using Ajax and Classic ASP
Converted from PHP to Classic ASP
http://roshanbh.com.np/2008/01/populate-triple-drop-down-list-change-options-value-from-database-using-ajax-and-php.html

This is something that is needed in many projects for both PHP and ASP Classic.
This took about 30 minutes to convert over and is a must need for any AJAX and ASP Classic developer.

View Demo Page«


<script language="javascript" type="text/javascript">
// Roshan's Ajax dropdown code with php
// This notice must stay intact for legal use
// Copyright reserved to Roshan Bhattarai - nepaliboy007@yahoo.com
// If you have any problem contact me at http://roshanbh.com.np
function getXMLHTTP() { //fuction to return the xml http object
        var xmlhttp=false; 
        try{
            xmlhttp=new XMLHttpRequest();
        }
        catch(e)    {      
            try{           
                xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
            }
            catch(e){
                try{
                xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
                }
                catch(e1){
                    xmlhttp=false;
                }
            }
        }
             
        return xmlhttp;
    }
     
    function getState(countryId) {     
         
        var strURL="findState.asp?country="+countryId;
        var req = getXMLHTTP();
         
        if (req) {
             
            req.onreadystatechange = function() {
                if (req.readyState == 4) {
                    // only if "OK"
                    if (req.status == 200) {                       
                        document.getElementById('statediv').innerHTML=req.responseText;                    
                    } else {
                        alert("There was a problem while using XMLHTTP:\n" + req.statusText);
                    }
                }              
            }          
            req.open("GET", strURL, true);
            req.send(null);
        }      
    }
    function getCity(countryId,stateId) {      
        var strURL="findCity.asp?country="+countryId+"&state="+stateId;
        var req = getXMLHTTP();
         
        if (req) {
             
            req.onreadystatechange = function() {
                if (req.readyState == 4) {
                    // only if "OK"
                    if (req.status == 200) {                       
                        document.getElementById('citydiv').innerHTML=req.responseText;                     
                    } else {
                        alert("There was a problem while using XMLHTTP:\n" + req.statusText);
                    }
                }              
            }          
            req.open("GET", strURL, true);
            req.send(null);
        }
                 
    }
</script>
Post to Facebook about: Populate triple drop down list from database using Ajax and Classic ASP