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

%>