var fieldname = document.getElementById(“Dtr”);dbLookup(“cidcn70001.cidc.cummins.com”,“PartsAndServices/CA 20Policy/PolicyA.nsf”,“Keyword”,“DistributorOEMcode”,2,fieldname);
//Tweaked By: Phani Reddy
//AJAX Lookup
function dbLookup(server,path,view,key,column,Name)
{
lkpKey=key
ObjCombo2=Name
//Put your second combo name here to get dblookup result
var pos=0;
currURL = (document.location.href).toLowerCase();
if (server == “”)
{
pos = currURL.indexOf(‘://’);
if (pos < 0 )
server = “http://10.50.3.107”
// Put your server name here
else
{
pos += 3;
pos = currURL.indexOf(‘/’, pos);
server = currURL.substring(0, pos)
}
}
if( path == “” )
{
if( pos > 0 )
{
newPos = currURL.indexOf('.nsf',pos);
if (newPos > 0)
{
path = currURL.substring(pos+1,newPos+4)
}
}
}
if( !isNaN(column) )
column -= 1;
//vurl = “http://”+server+“/”+“OR0603/Parts And Services/Development/PolicyA.nsf”+“/”+view+“?ReadViewEntries&Collapse=2&RestrictToCategory=”+lkpKey
vurl = “http://”+server+“/”+“PartsAndServices/CA 20Policy/PolicyA.nsf”+“/”+view+“?ReadViewEntries&Collapse=2&RestrictToCategory=”+lkpKey
//checking whether browser is mozila or Netscape
if (window.XMLHttpRequest)
{
req = new XMLHttpRequest();
req.overrideMimeType(‘text/xml’);
req.onreadystatechange = processReqChange_lookup;
req.open(“GET”, vurl , true);
req.send(null);
}
//checking whether browser is IE
else if (window.ActiveXObject)
{
req = new ActiveXObject(“Microsoft.XMLHTTP”);
if (req)
{
req.onreadystatechange = processReqChange_lookup;
req.open(“GET”, vurl, true);
req.send();
}
}
}
/* Function used to check whether
XML file loaded completely or not */
function processReqChange_lookup()
{
if (req.readyState == 4)
/*Only process if XML
file is loaded completely:4=“Complete” */
{
if (req.status == 200)
/Only process if everything is ok/
{
response = req.responseXML.documentElement;
populatelookup(response)
}
else
{
alert("There was a problem retrieving the XML data in " + req.statusText);
}
}
}
/* Function used to extract
value one by one from XML file */
function populatelookup(responseXML)
{
NodeList = responseXML.getElementsByTagName(“text”)
var tmplkpstr="";
var sep="";
for(var i=0; i<NodeList.length; i++)
{
tmplkpstr = tmplkpstr+sep+NodeList[i].childNodes[0].nodeValue
sep=“#”
}
finallkpresult = tmplkpstr.split(“#”)
writeInCombo(finallkpresult,ObjCombo2)
}
function writeInCombo(data,fldCombo)
{
fldCombo.length=0
fldCombo.length +=1
fldCombo[fldCombo.length-1].text = “–Select–”
for(iCount=0;iCount<data.length;iCount++)
{
fldCombo.length +=1
strText=data[iCount]
if (strText !=undefined && strText != null)
{
fldCombo[fldCombo.length-1].text = strText
}
}
}