Results 1 to 2 of 2

Thread: Option and JS-function with arrays

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2001
    Location
    Denmark
    Posts
    1,049

    Option and JS-function with arrays

    I have a JS function that reads my information from a database and put these into an array. I have 9 equal rows with the same array, I have tried to use the same array but it fails. Instead I use nine equal arrays, but this procedure is very slow. Can some of you tell me if I can use only one array?
    Code:
    <%
    'This is the database connection
    	set myconn2 = server.createobject("ADODB.connection")
    	myconn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&server.mappath("priser.mdb")
    	
    	sqlKomp = "SELECT * FROM komponenter ORDER BY id ASC"
    	set rs1 = myconn2.execute(sqlKomp)
    	sqlMe = "SELECT * FROM medieMat ORDER BY id ASC"
    	set rs2 = myconn2.execute(sqlMe)
    	sqlKap = "SELECT * FROM kappeMat ORDER BY id ASC"
    	set rs3 = myconn2.execute(sqlKap)
    	sqlMelde = "SELECT * FROM melde ORDER BY id ASC"
    	set rs4 = myconn2.execute(sqlMelde)
    	sqlDim = "SELECT * FROM medieDim ORDER BY id ASC"
    	set rs5 = myconn2.execute(sqlDim)
    	sqlSer = "SELECT * FROM serie ORDER BY id ASC"
    	set rs6 = myconn2.execute(sqlSer)
    	set rs7 = myconn2.execute(sqlSer)
    	set rs8 = myconn2.execute(sqlSer)
    	
    	
    	'Råpris på medierør 12 m
    	sqlSaetKomponenter = "SELECT * FROM Komponenter, Materiale_komponenter WHERE Komponenter.ID=Materiale_komponenter.KompId" 	
    	set rs10 = myconn2.execute(sqlSaetKomponenter)
    			
    	matId = Request.QueryString("matId")	
    	
    x=0	
    %>
    <script language="JavaScript">
    function createDependantList(formName, selectedItem)
    {
    update();
    
    for (k=1;k<10;k++) {
    	document.forside.elements('dimen'+k).length = 0 
    	document.forside.elements('afg'+k).length = 0 
    	document.forside.elements('komp'+k).length = 0
    } 
    <% 
    itemCount = 0
    y = 0
    do while not rs5.eof 
    	%>
    	x = <%=trim(y) %>
    
    	aryDims = new Array();
    	aryDims1 = new Array();
    	aryDims2 = new Array();
    	aryDims3 = new Array();
    	aryDims4 = new Array();
    	aryDims5 = new Array();
    	aryDims6 = new Array();
    	aryDims7 = new Array();
    	aryDims8 = new Array();
    	aryDims9 = new Array();
    	aryDims10 = new Array();
    	aryDims11 = new Array();
    	aryDims12 = new Array();
    	aryDims13 = new Array();
    	aryDims14 = new Array();
    	aryDims15 = new Array();
    	aryDims16 = new Array();
    	aryDims17 = new Array();
    		
    	DimID = "<%=trim(rs5("ID"))%>"
    	matID = "<%=trim(rs5("MatID"))%>"
    	dimensio = "<%=trim(rs5("Dimension"))%>"
    	//1.row
    	aryDims[x,0] = DimID;
    	aryDims[x,1] = matID;
    	aryDims[x,2] = dimensio;
    	aryDims1[x,0] = DimID;
    	aryDims1[x,1] = matID;
    	aryDims1[x,2] = dimensio;
    	//2.row
    	aryDims2[x,0] = DimID;
    	aryDims2[x,1] = matID;
    	aryDims2[x,2] = dimensio;
    	aryDims3[x,0] = DimID;
    	aryDims3[x,1] = matID;
    	aryDims3[x,2] = dimensio;
    	//3.row
    	aryDims4[x,0] = DimID;
    	aryDims4[x,1] = matID;
    	aryDims4[x,2] = dimensio;
    	aryDims5[x,0] = DimID;
    	aryDims5[x,1] = matID;
    	aryDims5[x,2] = dimensio;	
    	//4.row
    	aryDims6[x,0] = DimID;
    	aryDims6[x,1] = matID;
    	aryDims6[x,2] = dimensio;
    	aryDims7[x,0] = DimID;
    	aryDims7[x,1] = matID;
    	aryDims7[x,2] = dimensio;	
    	//5.row
    	aryDims8[x,0] = DimID;
    	aryDims8[x,1] = matID;
    	aryDims8[x,2] = dimensio;
    	aryDims9[x,0] = DimID;
    	aryDims9[x,1] = matID;
    	aryDims9[x,2] = dimensio;	
    	//6.row
    	aryDims10[x,0] = DimID;
    	aryDims10[x,1] = matID;
    	aryDims10[x,2] = dimensio;
    	aryDims11[x,0] = DimID;
    	aryDims11[x,1] = matID;
    	aryDims11[x,2] = dimensio;	
    	//7.row
    	aryDims12[x,0] = DimID;
    	aryDims12[x,1] = matID;
    	aryDims12[x,2] = dimensio;
    	aryDims13[x,0] = DimID;
    	aryDims13[x,1] = matID;
    	aryDims13[x,2] = dimensio;	
    	//8.row
    	aryDims14[x,0] = DimID;
    	aryDims14[x,1] = matID;
    	aryDims14[x,2] = dimensio;
    	aryDims15[x,0] = DimID;
    	aryDims15[x,1] = matID;
    	aryDims15[x,2] = dimensio;	
    	//9.row
    	aryDims16[x,0] = DimID;
    	aryDims16[x,1] = matID;
    	aryDims16[x,2] = dimensio;
    	aryDims17[x,0] = DimID;
    	aryDims17[x,1] = matID;
    	aryDims17[x,2] = dimensio;	
    	
    	if (aryDims[x,1] == selectedItem){
    			var option<%=trim(itemCount) %> = new Option(aryDims[x,2], aryDims[x,0])
    			formName.elements('dimen1').options[formName.elements('dimen1').length]=option<%=trim(itemCount)%>
    			var option<%=trim(itemCount) %> = new Option(aryDims1[x,2], aryDims1[x,0])
    			formName.elements('afg1').options[formName.elements('afg1').length]=option<%=trim(itemCount)%>
    	}
    	//2. række
    	if (aryDims2[x,1] == selectedItem){
    			var option<%=trim(itemCount) %> = new Option(aryDims2[x,2], aryDims2[x,0])
    			formName.elements('dimen2').options[formName.elements('dimen2').length]=option<%=trim(itemCount)%>
    			var option<%=trim(itemCount) %> = new Option(aryDims3[x,2], aryDims3[x,0])
    			formName.elements('afg2').options[formName.elements('afg2').length]=option<%=trim(itemCount)%>
    	}
    	
    	//3. række
    	if (aryDims3[x,1] == selectedItem){
    			var option<%=trim(itemCount) %> = new Option(aryDims4[x,2], aryDims4[x,0])
    			formName.elements('dimen3').options[formName.elements('dimen3').length]=option<%=trim(itemCount)%>
    			var option<%=trim(itemCount) %> = new Option(aryDims5[x,2], aryDims5[x,0])
    			formName.elements('afg3').options[formName.elements('afg3').length]=option<%=trim(itemCount)%>
    	}
    	
    	... And so on	
    	
    	<%
    	itemCount = itemCount + 1
    	y = y + 1
    	rs5.movenext
    loop
    
    do while not rs10.eof 
    	%>
    	x = <%=trim(y) %>
    	aryDims = new Array();
    	KompID = "<%=trim(rs10("KompID"))%>"
    	MatID = "<%=trim(rs10("MatID"))%>"
    	Komponent = "<%=trim(rs10("Komponent"))%>"
    	//1. række
    	aryDims1[x,0] = KompID;
    	aryDims1[x,1] = MatID;
    	aryDims1[x,2] = Komponent;
    	//2. række
    	aryDims2[x,0] = KompID;
    	aryDims2[x,1] = MatID;
    	aryDims2[x,2] = Komponent;
    	//3. række
    	aryDims3[x,0] = KompID;
    	aryDims3[x,1] = MatID;
    	aryDims3[x,2] = Komponent;
    	//4. række
    	aryDims4[x,0] = KompID;
    	aryDims4[x,1] = MatID;
    	aryDims4[x,2] = Komponent;
    	//5. række
    	aryDims5[x,0] = KompID;
    	aryDims5[x,1] = MatID;
    	aryDims5[x,2] = Komponent;
    	//6. række
    	aryDims6[x,0] = KompID;
    	aryDims6[x,1] = MatID;
    	aryDims6[x,2] = Komponent;
    	//7. række
    	aryDims7[x,0] = KompID;
    	aryDims7[x,1] = MatID;
    	aryDims7[x,2] = Komponent;
    	//8. række
    	aryDims8[x,0] = KompID;
    	aryDims8[x,1] = MatID;
    	aryDims8[x,2] = Komponent;
    	//9. række
    	aryDims9[x,0] = KompID;
    	aryDims9[x,1] = MatID;
    	aryDims9[x,2] = Komponent;
    	
    	//1.række
    	if (aryDims1[x,1] == selectedItem){
    		var option<%=trim(itemCount) %> = new Option(aryDims1[x,2], aryDims1[x,0])
    		formName.elements('komp1').options[formName.elements('komp1').length]=option<%=trim(itemCount)%>
    	}
    	
    	//2.række
    	if (aryDims2[x,1] == selectedItem){
    		var option<%=trim(itemCount) %> = new Option(aryDims2[x,2], aryDims2[x,0])
    		formName.elements('komp2').options[formName.elements('komp2').length]=option<%=trim(itemCount)%>
    	}
    	
    	//3.række
    	if (aryDims3[x,1] == selectedItem){
    		var option<%=trim(itemCount) %> = new Option(aryDims3[x,2], aryDims3[x,0])
    		formName.elements('komp3').options[formName.elements('komp3').length]=option<%=trim(itemCount)%>
    	}
    	
    	//4.række
    	if (aryDims4[x,1] == selectedItem){
    		var option<%=trim(itemCount) %> = new Option(aryDims4[x,2], aryDims4[x,0])
    		formName.elements('komp4').options[formName.elements('komp4').length]=option<%=trim(itemCount)%>
    	}
    	
    	//5.række
    	if (aryDims5[x,1] == selectedItem){
    		var option<%=trim(itemCount) %> = new Option(aryDims5[x,2], aryDims5[x,0])
    		formName.elements('komp5').options[formName.elements('komp5').length]=option<%=trim(itemCount)%>
    	}
    	
    	//6.række
    	if (aryDims6[x,1] == selectedItem){
    		var option<%=trim(itemCount) %> = new Option(aryDims6[x,2], aryDims6[x,0])
    		formName.elements('komp6').options[formName.elements('komp6').length]=option<%=trim(itemCount)%>
    	}
    	
    	//7.række
    	if (aryDims7[x,1] == selectedItem){
    		var option<%=trim(itemCount) %> = new Option(aryDims7[x,2], aryDims7[x,0])
    		formName.elements('komp7').options[formName.elements('komp7').length]=option<%=trim(itemCount)%>
    	}
    	
    	//8.række
    	if (aryDims8[x,1] == selectedItem){
    		var option<%=trim(itemCount) %> = new Option(aryDims8[x,2], aryDims8[x,0])
    		formName.elements('komp8').options[formName.elements('komp8').length]=option<%=trim(itemCount)%>
    	}
    	
    	//9.række
    	if (aryDims9[x,1] == selectedItem){
    		var option<%=trim(itemCount) %> = new Option(aryDims9[x,2], aryDims9[x,0])
    		formName.elements('komp9').options[formName.elements('komp9').length]=option<%=trim(itemCount)%>
    	}
    
    	<%
    	itemCount = itemCount + 1
    	y = y + 1
    	rs10.movenext
    loop
    
    %>

  2. #2

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2001
    Location
    Denmark
    Posts
    1,049
    I've found out, sorry for taking time

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width