Hjælp med Loop i loop
Hej!Jeg har et stort problem med et loop som skal indeholde et andet loop.
Jeg har følgende selects :
'####### mainMenu ############
'## Create db objects and SQL
set mainmenuConn = Server.CreateObject("ADODB.Connection")
mainmenuConn.Open Application("ConnectString")
set rsmainmenu = Server.CreateObject("ADODB.Recordset")
mainmenuSql = "SELECT * FROM mainmenu ORDER BY mainmenu.recordid;"
set rsmainmenu = mainmenuConn.Execute(mainmenuSql)
'####### Menu ############
'## Create db objects and SQL
set menuConn = Server.CreateObject("ADODB.Connection")
menuConn.Open Application("ConnectString")
set rsmenu = Server.CreateObject("ADODB.Recordset")
menuSql = "SELECT DISTINCT mainmenu.mainmenu AS mainmenu, mainmenu.recordid AS recordid, link.link AS link FROM mainmenu INNER JOIN link ON mainmenu.recordid = link.menuid GROUP BY mainmenu.mainmenu, mainmenu.recordid, link.link ORDER BY mainmenu.recordid;"
set rsmenu = menuConn.Execute(menuSql)
og den løkke jeg ikke kan få til at virke skal være noget ala dette :
<tr>
<td width="100"><font size="1"><b> </b></font></td>
<td width="200">
<% While (not rsmainmenu.EOF)%>
<span id="sub<%=trim(rsmainmenu("recordid"))%>">
<select name="sub<%=rsmainmenu("mainmenu")%>" onchange="closeselect(this,'sub<%=trim(rsmainmenu("recordid"))%>')">
<option selected value="">Vælg...</option>
<% While (not rsmenu.EOF)%>
<option value="<%=rsmenu("linkname")%>"><%=rsmenu("linkname")%></option>
<% rsmenu.movenext
wend
%>
</select>
</span>
<% rsmainmenu.movenext
wend
%>
</td>
</tr>
Resultatet af dette bliver
<tr>
<td width="100"><font size="1"><b> </b></font></td>
<td width="200"></td>
</tr>
Altså tomt!! Hmm og det skulle have set ud noget ala dette :
<span id="sub1">
<select name="subannounce" onchange="closeselect(this,'sub1')">
<option selected value="">- subcategory -
<option value="cars">cars
<option value="houses">houses
<option value="guitars">guitars
</select>
</span>
<span id="sub2">
<select name="subarts" onchange="closeselect(this,'sub2')">
<option selected value="">- subcategory -
<option value="music">music
<option value="lyrics">lyrics
<option value="painting">painting
</select>
</span>
<span id="sub3">
<select name="subsoftware" onchange="closeselect(this,'sub3')">
<option selected value="">- subcategory -
<option value="php">php
<option value="java">java
<option value="asp">asp
<option value="mysql">mysql
</select>
</span>
Er der nogen der kan hjælpe mig med dette????
På for hånd tak *S
/Stig :-)
