effettuo una query ed ho dei risultati devo impaginarli come fare ?
Questo è il codice della mia pagina
<!--#include file="database_serraggio.asp" -->
<%
parola=request("parola")
Dim strTermine, ArrTermine
strTermine = trimmalo(parola)
ArrTermine = Split(strTermine," ")
%>
<html>
<head>
<title>RDP - rdp on line </title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="stile.css" type="text/css">
<link rel="stylesheet" href="stile.css" type="text/css">
</head>
<script>
//verifico che il campo CERCA non sia vuoto
function FrontPage_Form2_Validator(Form2)
{
if (form2.parola.value == "")
{
alert("Inserire almeno un temine per la ricerca.");
form2.parola.focus();
return (false);
}
return (true);
}
//-->
//verifico che il campo email della newsletter non sia vuoto
</script>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="780" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"> </td>
</tr>
<tr>
<td valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top">
<form name="form2" method="post" action="ricerca_serraggio.asp" onsubmit="return FrontPage_Form2_Validator(this)">
<div align="center">
<table width="200" border="0" cellspacing="0" cellpadding="0" id=testo>
<tr bgcolor="#FFCC00">
<td bgcolor="#003399" height="13" id=testo><font color="#FFCC00"><b> Cerca
il modello di macchina</b></font></td>
<tr>
<td bgcolor="#FFCC00" height="50" style="border: 1 solid #003399">
<div align="center">
<SCRIPT language=JavaScript>
<!--
if(document.layers){
document.write("<input type='text' size='9' name='parola'>");
}
if(document.all){
document.write("<input type='text' size='15' name='parola'>");
}
//-->
</SCRIPT>
<input type="image" src="invia_newletter.gif" width="50" height="13" name="image" title="Cerca">
</div>
</td>
</tr>
</table>
</div>
</form>
<br>
<div align="center"> <br>
</div>
</td>
<td width="560" valign="top">
<div align="center">
<table width="560" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#003399" height="13" id=testo width="186"> <b><font color="#FFCC00">Risultati
della ricerca:</font></b></td>
<td height="13" id=testo width="374"> <font color="#003399">il
motore di ricerca di </font><b><font color="#003399"> RDP
- rdp on line </font></b></td>
<tr valign="top" bgcolor="#FFFFFF">
<td style="border: 1 solid #003399" colspan="2" id=testo>
<div align="center">
<!--RICERCA -->
<% connessione
sql=" SELECT id from dati WHERE "
for i=1 to UBound(ArrTermine)
if i>1 then sql = sql&" OR "
sql= sql&" (mc LIKE '%"&ArrTermine(i)&"%') OR (md LIKE '%"&ArrTermine(i)&"%') OR (an_da LIKE '%"&ArrTermine(i)&"%') and on_line=True"
next
set rs=conn.execute (sql)
if not rs.eof then
%>
<br>
<b><font color="#003399"><b>Modello Auto</b></font></b><font color="#003399" size="2"><b>
</b></font><font color="#003399"> trovati con il termine
"<b><font color="#FF6633">
<% =ucase(request("parola"))%>
</font></b>":</font> <br>
<br>
<table width="79%" border="0" cellspacing="0" cellpadding="0" height="28" style="border: 1 dashed #6699CC" id=testo>
<% do while not rs.eof
set rs2=query("select * from dati where id="&rs("id")&" order by data desc ")
%>
<tr valign="top">
<td width="18" height="10" rowspan="9" id=testo align="center">
<div align="center"></div>
</td>
<td height="2" id=testo colspan="2"> </td>
</tr>
<tr valign="top">
<td colspan="3" height="10" id=testo align="center" valign="middle">
<div align="left"><b></b></div>
</td>
</tr>
<tr valign="top">
<td width="18" height="10" id=testo align="center"> </td>
<td width="176" height="3" id=testo><b class="medio">Marca
motore</b></td>
<td width="248" height="3" id=testo><b>
<a class="small" href="elenco.asp?id=<%=rs("id")%>"><%=rs2("mc")%></a>
</b></td>
</tr>
<tr valign="top">
<td width="18" height="10" id=testo align="center"> </td>
<td width="176" height="3" id=testo><b class="medio">Modello
auto</b></td>
<td width="248" height="3" id=testo><%=rs2("md")%></td>
</tr>
<tr valign="top">
<td width="18" height="10" id=testo align="center"> </td>
<td width="176" height="3" id=testo><b class="medio">Anno
da</b></td>
<td width="248" height="3" id=testo><%=rs2("an_da")%></td>
</tr>
<tr valign="top">
<td width="18" height="10" id=testo align="center"> </td>
<td width="176" height="3" id=testo><b>Cilindrata motore
</b></td>
<td width="248" height="3" id=testo><%=rs2("cc")%></td>
</tr>
<tr valign="top">
<td width="18" height="10" id=testo align="center"> </td>
<td width="176" height="3" id=testo><b>Data</b></td>
<td width="248" height="3" id=testo><b><font color="#993300"><%=rs2("data")%></font></b></td>
</tr>
<% rs.movenext
rs2.close
loop
%>
</table>
<br>
<br>
<%
else
%>
<br>
<br>
<font color="#003399">Nessun <b>Modello Auto </b> trovato
con il termine "<b><font color="#FF6633">
<% =ucase(request("parola"))%>
</font></b>".</font>
<% end if %>
</div>
<!--FINE RICERCA -->
<br>
<br>
<br>
</td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td colspan="2" valign="top" id=testo>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td id=testo height="40" colspan="2">
<div align="center"></div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
