<% sql = "SELECT nome FROM linee WHERE id=" & request("linea") set rs=conn.execute(CleanSQL(sql)) linea=rs("nome") sql = "SELECT * FROM categorie WHERE linea=" & request("linea") if request("categoria")<>"" then sql=sql+" AND id=" + request("categoria") sql=sql + " ORDER BY ordine" set rs=conn.execute(CleanSQL(sql)) id_categoria=rs("id") categoria=rs("nome") d_categoria=rs("descrizione") foto=rs("foto") pdf=rs("pdf") %> CATALOGO

Linea: <%=linea%>

 

<%=categoria%>

 

<%=d_categoria%>

<%if pdf<>"" then%>

Scarica la scheda tecnica della serie in formato PDF

<%end if%>

 

<%if foto<>"" then%>

 

<%end if%>

<% sql = "SELECT * FROM categorie WHERE linea=" & request("linea") & " ORDER BY ordine" set rs=conn.execute(CleanSQL(sql)) do while Not rs.eof %> <% rs.MoveNext loop %>

MODELLI

> &categoria=<%=rs("id")%>"> <%=rs("nome")%> <%if cint(id_categoria)=rs("id") then%> <% sql = "SELECT * FROM prodotti WHERE categoria=" & id_categoria & " ORDER BY ordine" set rs2=conn.execute(CleanSQL(sql)) do while Not rs2.eof %> <% rs2.MoveNext loop %>
> &categoria=<%=rs("id")%>&prodotto=<%=rs2("id")%>"> <%=rs2("nome")%><%if rs2("ultimarevisione")<>"" then response.write(" [ " & rs2("ultimarevisione") & " ]")%>
<%end if%>