<% sql = "SELECT e_nome FROM linee WHERE id=" & request("linea") set rs=conn.execute(CleanSQL(sql)) linea=rs("e_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("e_nome") d_categoria=rs("e_descrizione") foto=rs("foto") pdf=rs("pdf") %> CATALOG

Line: <%=linea%>

 

<%=categoria%>

 

<%=d_categoria%>

<%if pdf<>"" then%>

Scarica la scheda tecnica della serie in formato PDF

<%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 %>

MODELS

> &categoria=<%=rs("id")%>"> <%=rs("e_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("e_nome")%>
<%end if%>