NOVITÀ
- generatori di aria calda KP
Categoria
<%'*********** Carico la tabella Serie ************************************* 'arcst2="PIA" SQLquery = "SELECT * FROM Cat_Merceologica" set rsSerie = conn.Execute(SQLquery) %>
Tutti i pezzi ----
<%while not rsSerie.eof 'arcst7 = "" & rsSerie("CODICE") 'SQLquery = "SELECT * FROM REC_PRODOTTO WHERE ARCST2 LIKE '" & arcst2 & "' AND ARCST7 = '" & arcst7 & "'" 'set rsTipo = conn.Execute(SQLquery) 'if not rsTipo.eof then %>
selected <% end if %> value="<%= rsSerie("ID") %>"> <%= rsSerie("Cat_merceologica")%>
<% 'end if rsSerie.movenext wend rsSerie.close set rsSerie = nothing '*******************************************************************************%>
Classe Prodotto
<%'*********** Carico la tabella Modulo ************************************* SQLquery = "SELECT * FROM Classe_Prodotto" set rsModulo = conn.Execute(SQLquery)%>
Tutti i pezzi ----
<%while not rsModulo.eof 'arcst6 = "" & rsModulo("CODICE") 'SQLquery = "SELECT * FROM REC_PRODOTTO WHERE ARCST2 LIKE '" & arcst2 & "' AND ARCST6 = '" & arcst6 & "'" 'set rsTipo = conn.Execute(SQLquery) 'if not rsTipo.eof then %>
selected <% end if %> value="<%= rsModulo("ID") %>"> <%= rsModulo("Classe")%>
<% 'end if rsModulo.movenext wend rsModulo.close set rsModulo = nothing '*******************************************************************************%>
Tipologia
<%'*********** Carico la tabella Caratteristiche ************************************* SQLquery = "SELECT * FROM Sotto_Classe" set rsCaratteristiche = conn.Execute(SQLquery)%>
Tutti i pezzi ----
<%while not rsCaratteristiche.eof 'arcst4 = "" & rsCaratteristiche("CODICE") ' SQLquery = "SELECT * FROM REC_PRODOTTO WHERE ARCST2 LIKE '" & arcst2 & "' AND ARCST4 = '" & arcst4 & "'" 'set rsTipo = conn.Execute(SQLquery) 'if not rsTipo.eof then%>
selected <% end if %> value="<%= rsCaratteristiche("ID") %>"> <%= rsCaratteristiche("Sotto_Classe")%>
<% 'end if rsCaratteristiche.movenext wend rsCaratteristiche.close set rsCaratteristiche = nothing '*******************************************************************************%>