<%data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _ Server.MapPath("../database/Artisandata.mdb") Set con = Server.CreateObject ("ADODB.Connection") con.open data_source sql="select cl.Codice, cl.Rag_Sociale, cm.Comune from Clienti cl, Comuni cm where cl.C_Citta = cm.Codice And cl.Tipo = 'A' Order by cl.Rag_Sociale, cm.Comune;" Set RS=con.execute(sql) %>
Tuscan
ARTISANS
 ARTISANDATA
List of Artisans
<% Flag = False%> <% Do while NOT RS.EOF %> <% Flag = Not Flag %> <% If Flag Then%> <%Else%> <% End If RS.MoveNext Loop RS.Close con.close %>
"><%=rs("Rag_Sociale")%> <%=rs("Comune")%>
"><%=rs("Rag_Sociale")%> <%=rs("Comune")%>
   
 
ARTS & CRAFTS
THE GREATEST
FLORENCE
HANDIWORK
ARTS & CRAFTS
OF FLORENCE
FLORENCE
AND
ARTS
TUSCANY
FLORENCE