|
-
Sep 4th, 2002, 02:53 AM
#1
Thread Starter
Frenzied Member
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
%>
-
Sep 4th, 2002, 06:23 AM
#2
Thread Starter
Frenzied Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|