<%@page contentType="text/html" import="SiteEngine.*,db1.*"%> <% SqlSearch hSqlSearch = new SqlSearch(request); dbPager hPager = new dbPager("TVAVICENZA", request, 50, 20, request.getRequestURI()); hPager.Sql(hSqlSearch.getSql("select palinsesto.*, testiarticoli.linkarticolo1 from palinsesto left join testiarticoli on palinsesto.link = testiArticoli.idArticolo where (((datepart(dw,getdate())=2 and palinsesto.lun='S') or (datepart(dw,getdate())=3 and palinsesto.mar='S') or (datepart(dw,getdate())=4 and palinsesto.mer='S') or (datepart(dw,getdate())=5 and palinsesto.gio='S') or (datepart(dw,getdate())=6 and palinsesto.ven='S') or (datepart(dw,getdate())=7 and palinsesto.sab='S') or (datepart(dw,getdate())=1 and palinsesto.dom='S')) or (palinsesto.data=getdate())) and (testiarticoli.pagina is null or testiarticoli.pagina='1') and (testiarticoli.idLingua='ITA' or testiarticoli.idLingua is null) and (palinsesto.datainiziale is null or palinsesto.datainiziale <= getdate()) and (palinsesto.datafinale is null or palinsesto.datafinale >= getdate()) order by ordinale,ora")); %> function palinsesto() { document.write(""); <% while (hPager.next()) { out.print("document.write('');"); out.print("document.write('\");"); out.print("document.write('');"); }%> document.write("

');"); out.print("document.write('"+hPager.get("ora")+"

');"); out.print("document.write(\""+hPager.get("titolo")+"

"); } <% //hPager.close(); //hPager = dbPager("TVAVICENZA", request, 50, 20, request.getRequestURI()); hPager.Sql(hSqlSearch.getSql("select palinsesto.*, testiarticoli.linkarticolo1 from palinsesto left join testiarticoli on palinsesto.link = testiArticoli.idArticolo where ora < '12' and ordinale='N' and (((datepart(dw,getdate())=2 and palinsesto.lun='S') or (datepart(dw,getdate())=3 and palinsesto.mar='S') or (datepart(dw,getdate())=4 and palinsesto.mer='S') or (datepart(dw,getdate())=5 and palinsesto.gio='S') or (datepart(dw,getdate())=6 and palinsesto.ven='S') or (datepart(dw,getdate())=7 and palinsesto.sab='S') or (datepart(dw,getdate())=1 and palinsesto.dom='S')) or (palinsesto.data=getdate())) and (testiarticoli.pagina is null or testiarticoli.pagina='1') and (testiarticoli.idLingua='ITA' or testiarticoli.idLingua is null) and (palinsesto.datainiziale is null or palinsesto.datainiziale <= getdate()) and (palinsesto.datafinale is null or palinsesto.datafinale >= getdate()) order by ordinale,ora")); %> function palinsesto_mattino() { document.write(""); <% while (hPager.next()) { out.print("document.write('');"); out.print("document.write('\");"); out.print("document.write('');"); }%> document.write("

');"); out.print("document.write('"+hPager.get("ora")+"

');"); out.print("document.write(\""+hPager.get("titolo")+"

"); } <% //hPager.close(); //hPager = dbPager("TVAVICENZA", request, 50, 20, request.getRequestURI()); hPager.Sql(hSqlSearch.getSql("select palinsesto.*, testiarticoli.linkarticolo1 from palinsesto left join testiarticoli on palinsesto.link = testiArticoli.idArticolo where (ora >= '12' and ora <='18') and (((datepart(dw,getdate())=2 and palinsesto.lun='S') or (datepart(dw,getdate())=3 and palinsesto.mar='S') or (datepart(dw,getdate())=4 and palinsesto.mer='S') or (datepart(dw,getdate())=5 and palinsesto.gio='S') or (datepart(dw,getdate())=6 and palinsesto.ven='S') or (datepart(dw,getdate())=7 and palinsesto.sab='S') or (datepart(dw,getdate())=1 and palinsesto.dom='S')) or (palinsesto.data=getdate())) and (testiarticoli.pagina is null or testiarticoli.pagina='1') and (testiarticoli.idLingua='ITA' or testiarticoli.idLingua is null) and (palinsesto.datainiziale is null or palinsesto.datainiziale <= getdate()) and (palinsesto.datafinale is null or palinsesto.datafinale >= getdate()) order by ordinale,ora")); %> function palinsesto_pomeriggio() { document.write(""); <% while (hPager.next()) { out.print("document.write('');"); out.print("document.write('\");"); out.print("document.write('');"); }%> document.write("

');"); out.print("document.write('"+hPager.get("ora")+"

');"); out.print("document.write(\""+hPager.get("titolo")+"

"); } <% //hPager.close(); //hPager = dbPager("TVAVICENZA", request, 50, 20, request.getRequestURI()); hPager.Sql(hSqlSearch.getSql("select palinsesto.*, testiarticoli.linkarticolo1 from palinsesto left join testiarticoli on palinsesto.link = testiArticoli.idArticolo where (ora > '18' or ordinale='S') and (((datepart(dw,getdate())=2 and palinsesto.lun='S') or (datepart(dw,getdate())=3 and palinsesto.mar='S') or (datepart(dw,getdate())=4 and palinsesto.mer='S') or (datepart(dw,getdate())=5 and palinsesto.gio='S') or (datepart(dw,getdate())=6 and palinsesto.ven='S') or (datepart(dw,getdate())=7 and palinsesto.sab='S') or (datepart(dw,getdate())=1 and palinsesto.dom='S')) or (palinsesto.data=getdate())) and (testiarticoli.pagina is null or testiarticoli.pagina='1') and (testiarticoli.idLingua='ITA' or testiarticoli.idLingua is null) and (palinsesto.datainiziale is null or palinsesto.datainiziale <= getdate()) and (palinsesto.datafinale is null or palinsesto.datafinale >= getdate()) order by ordinale,ora")); %> function palinsesto_sera() { document.write(""); <% while (hPager.next()) { out.print("document.write('');"); out.print("document.write('\");"); out.print("document.write('');"); }%> document.write("

');"); out.print("document.write('"+hPager.get("ora")+"

');"); out.print("document.write(\""+hPager.get("titolo")+"

"); }