%
conn = OpenCn
sqlCa = "SELECT * From categorie"
set rsCat = server.createObject("ADODB.Recordset")
Set rsCat = OpenRs(conn,sqlCa)
%>
<%
conn = OpenCn
sqlCa = "SELECT * From categorieofferte"
set rsCaz = server.createObject("ADODB.Recordset")
Set rsCaz = OpenRs(conn,sqlCa)
%>
<%
conn = OpenCn
codPro = request.querystring("cod")
sqlCa = "SELECT * From categorie"
set rsCat = server.createObject("ADODB.Recordset")
Set rsCat = OpenRs(conn,sqlCa)
%>
<%
codice = request.QueryString("n")
conn = OpenCn
Set conn2 = Server.CreateObject("ADODB.Connection")
conn2.open ("server=" & DBserver & ";db=" & DBname & _
";uid=" & utente & ";pwd=" & password & ";driver=" & DBdriver)
sqlS = "SELECT * From schede where idart=" & codice
Set rsS = OpenRs(conn2,sqlS)
sqlC = "SELECT * From correlati LEFT JOIN articoli ON articoli.ID=correlati.idartcor where correlati.idart=" & codice
set rsC = server.createObject("ADODB.Recordset")
Set rsC = OpenRs(conn2,sqlC)
sqlF = "SELECT * From articoli WHERE id_padre=" & codice
set rsF = server.createObject("ADODB.Recordset")
Set rsF = OpenRs(conn,sqlF)
sql = "SELECT * From articoli where ID=" & codice
set rs = server.createObject("ADODB.Recordset")
Set rs = OpenRs(conn,sql)
%>
Bed & Breakfast Smile - B&B Caltanissetta - Dormire a Caltanissetta - Hotel - Residence - Albergo