Il codice con la seconda modifica è:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title></title>
</head>
<body background="images/sfondo rist.jpg">
<!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="Nome,Indirizzo,Città,Provincia,Regione,N° telefono,Giudizio,Rapporto_QP,Tipo cucina,Prezzo medio,Alimenti consigliati,Alimenti sconsigliati,Vini consigliati,Vini sconsigliati,Note,Ultima visita,Recensore,Giorno di chiusura"
s-columntypes="202,202,202,202,202,202,5,5,202,5,202,202,202,202,202,135,202,202"
s-dataconnection="Database1" b-tableformat="FALSE" b-menuformat="FALSE"
s-menuchoice="Nome" s-menuvalue="Nome" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="7"
b-makeform="TRUE" s-recordsource
s-displaycolumns="Nome,Indirizzo,Città,Provincia,Regione,N° telefono,Giudizio,Rapporto_QP,Tipo cucina,Prezzo medio,Alimenti consigliati,Alimenti sconsigliati,Vini consigliati,Vini sconsigliati,Note,Ultima visita,Recensore,Giorno di chiusura"
s-criteria s-order
s-sql="SELECT * FROM "Singolo Nome" where Nome='" & Request.QueryString("Nome") & "'"
b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields
s-NoRecordsFound="Ristorante non trovato" i-MaxRecords="0" i-GroupSize="0"
BOTID="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY"
local_preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">Database Results regions will not preview unless this page is fetched from a Web server using a web browser. The section of the page from here to the end of the Database Results region will repeat once for each record returned by the query.</font></td></tr></table>"
preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" b-WasTableFormat="FALSE" --><!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM ""Singolo Nome"" where Nome='"" & Request.QueryString(""Nome"") & ""'"
fp_sDefault=""
fp_sNoRecords="Ristorante non trovato"
fp_sDataConn="Database1"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="Nome"
fp_sMenuValue="Nome"
fp_iDisplayCols=18
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<%
response.write "|" & fp_sQry & "|"
%>
<!--webbot bot="DatabaseRegionStart" i-CheckSum="1482" endspan -->
<form METHOD="POST">
<!--webbot bot="PurpleText"
PREVIEW="Set this form's properties so it submits user input to the appropriate page."
-->
<table BORDER="0">
<tr>
<td><b>Nome:</b></td>
<td><input TYPE="TEXT" NAME="Nome" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Nome")%>"></td>
</tr>
<tr>
<td><b>Indirizzo:</b></td>
<td><input TYPE="TEXT" NAME="Indirizzo" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Indirizzo")%>"></td>
</tr>
<tr>
<td><b>Città:</b></td>
<td><input TYPE="TEXT" NAME="Città" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Città")%>"></td>
</tr>
<tr>
<td><b>Provincia:</b></td>
<td><input TYPE="TEXT" NAME="Provincia" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Provincia")%>"></td>
</tr>
<tr>
<td><b>Regione:</b></td>
<td><input TYPE="TEXT" NAME="Regione" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Regione")%>"></td>
</tr>
<tr>
<td><b>N° telefono:</b></td>
<td><input TYPE="TEXT" NAME="N° telefono" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"N° telefono")%>"></td>
</tr>
<tr>
<td><b>Giudizio:</b></td>
<td><input TYPE="TEXT" NAME="Giudizio" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Giudizio")%>"></td>
</tr>
<tr>
<td><b>Rapporto_QP:</b></td>
<td><input TYPE="TEXT" NAME="Rapporto_QP" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Rapporto_QP")%>"></td>
</tr>
<tr>
<td><b>Tipo cucina:</b></td>
<td><input TYPE="TEXT" NAME="Tipo cucina" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Tipo cucina")%>"></td>
</tr>
<tr>
<td><b>Prezzo medio:</b></td>
<td><input TYPE="TEXT" NAME="Prezzo medio" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Prezzo medio")%>"></td>
</tr>
<tr>
<td><b>Alimenti consigliati:</b></td>
<td><input TYPE="TEXT" NAME="Alimenti consigliati" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Alimenti consigliati")%>"></td>
</tr>
<tr>
<td><b>Alimenti sconsigliati:</b></td>
<td><input TYPE="TEXT" NAME="Alimenti sconsigliati" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Alimenti sconsigliati")%>"></td>
</tr>
<tr>
<td><b>Vini consigliati:</b></td>
<td><input TYPE="TEXT" NAME="Vini consigliati" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Vini consigliati")%>"></td>
</tr>
<tr>
<td><b>Vini sconsigliati:</b></td>
<td><input TYPE="TEXT" NAME="Vini sconsigliati" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Vini sconsigliati")%>"></td>
</tr>
<tr>
<td><b>Note:</b></td>
<td><input TYPE="TEXT" NAME="Note" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Note")%>"></td>
</tr>
<tr>
<td><b>Ultima visita:</b></td>
<td><input TYPE="TEXT" NAME="Ultima visita" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Ultima visita")%>"></td>
</tr>
<tr>
<td><b>Recensore:</b></td>
<td><input TYPE="TEXT" NAME="Recensore" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Recensore")%>"></td>
</tr>
<tr>
<td><b>Giorno di chiusura:</b></td>
<td><input TYPE="TEXT" NAME="Giorno di chiusura" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Giorno di chiusura")%>"></td>
</tr>
<tr>
<td COLSPAN="2"><br>
<input TYPE="Submit" NAME="fp_submit"><input TYPE="Reset" NAME="fp_reset"></td>
</tr>
</table>
</form>
<hr>
<!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside
tag="BODY"
local_preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="center"><font color="#000000">End of Database Results region.</font></td></tr></table>"
preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" i-CheckSum="62730" endspan -->
</body>
</html>
Il codice con la prima modifica è:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title></title>
</head>
<body background="images/sfondo rist.jpg">
<!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="Nome,Indirizzo,Città,Provincia,Regione,N° telefono,Giudizio,Rapporto_QP,Tipo cucina,Prezzo medio,Alimenti consigliati,Alimenti sconsigliati,Vini consigliati,Vini sconsigliati,Note,Ultima visita,Recensore,Giorno di chiusura"
s-columntypes="202,202,202,202,202,202,5,5,202,5,202,202,202,202,202,135,202,202"
s-dataconnection="Database1" b-tableformat="FALSE" b-menuformat="FALSE"
s-menuchoice="Nome" s-menuvalue="Nome" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="7"
b-makeform="TRUE" s-recordsource
s-displaycolumns="Nome,Indirizzo,Città,Provincia,Regione,N° telefono,Giudizio,Rapporto_QP,Tipo cucina,Prezzo medio,Alimenti consigliati,Alimenti sconsigliati,Vini consigliati,Vini sconsigliati,Note,Ultima visita,Recensore,Giorno di chiusura"
s-criteria s-order
s-sql="SELECT * FROM "Singolo Nome" where Nome='" & Request.QueryString("Nome") & "'"
b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields
s-NoRecordsFound="Ristorante non trovato" i-MaxRecords="0" i-GroupSize="0"
BOTID="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY"
local_preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">Database Results regions will not preview unless this page is fetched from a Web server using a web browser. The section of the page from here to the end of the Database Results region will repeat once for each record returned by the query.</font></td></tr></table>"
preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" b-WasTableFormat="FALSE" --><!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM ""Singolo Nome"" where Nome='"" & Request.QueryString(""Nome"") & ""'"
response.write "|" & fp_sQry & "|"
fp_sDefault=""
fp_sNoRecords="Ristorante non trovato"
fp_sDataConn="Database1"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="Nome"
fp_sMenuValue="Nome"
fp_iDisplayCols=18
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" i-CheckSum="1482" endspan -->
<form METHOD="POST">
<!--webbot bot="PurpleText"
PREVIEW="Set this form's properties so it submits user input to the appropriate page."
-->
<table BORDER="0">
<tr>
<td><b>Nome:</b></td>
<td><input TYPE="TEXT" NAME="Nome" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Nome")%>"></td>
</tr>
<tr>
<td><b>Indirizzo:</b></td>
<td><input TYPE="TEXT" NAME="Indirizzo" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Indirizzo")%>"></td>
</tr>
<tr>
<td><b>Città:</b></td>
<td><input TYPE="TEXT" NAME="Città" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Città")%>"></td>
</tr>
<tr>
<td><b>Provincia:</b></td>
<td><input TYPE="TEXT" NAME="Provincia" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Provincia")%>"></td>
</tr>
<tr>
<td><b>Regione:</b></td>
<td><input TYPE="TEXT" NAME="Regione" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Regione")%>"></td>
</tr>
<tr>
<td><b>N° telefono:</b></td>
<td><input TYPE="TEXT" NAME="N° telefono" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"N° telefono")%>"></td>
</tr>
<tr>
<td><b>Giudizio:</b></td>
<td><input TYPE="TEXT" NAME="Giudizio" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Giudizio")%>"></td>
</tr>
<tr>
<td><b>Rapporto_QP:</b></td>
<td><input TYPE="TEXT" NAME="Rapporto_QP" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Rapporto_QP")%>"></td>
</tr>
<tr>
<td><b>Tipo cucina:</b></td>
<td><input TYPE="TEXT" NAME="Tipo cucina" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Tipo cucina")%>"></td>
</tr>
<tr>
<td><b>Prezzo medio:</b></td>
<td><input TYPE="TEXT" NAME="Prezzo medio" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Prezzo medio")%>"></td>
</tr>
<tr>
<td><b>Alimenti consigliati:</b></td>
<td><input TYPE="TEXT" NAME="Alimenti consigliati" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Alimenti consigliati")%>"></td>
</tr>
<tr>
<td><b>Alimenti sconsigliati:</b></td>
<td><input TYPE="TEXT" NAME="Alimenti sconsigliati" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Alimenti sconsigliati")%>"></td>
</tr>
<tr>
<td><b>Vini consigliati:</b></td>
<td><input TYPE="TEXT" NAME="Vini consigliati" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Vini consigliati")%>"></td>
</tr>
<tr>
<td><b>Vini sconsigliati:</b></td>
<td><input TYPE="TEXT" NAME="Vini sconsigliati" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Vini sconsigliati")%>"></td>
</tr>
<tr>
<td><b>Note:</b></td>
<td><input TYPE="TEXT" NAME="Note" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Note")%>"></td>
</tr>
<tr>
<td><b>Ultima visita:</b></td>
<td><input TYPE="TEXT" NAME="Ultima visita" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Ultima visita")%>"></td>
</tr>
<tr>
<td><b>Recensore:</b></td>
<td><input TYPE="TEXT" NAME="Recensore" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Recensore")%>"></td>
</tr>
<tr>
<td><b>Giorno di chiusura:</b></td>
<td><input TYPE="TEXT" NAME="Giorno di chiusura" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Giorno di chiusura")%>"></td>
</tr>
<tr>
<td COLSPAN="2"><br>
<input TYPE="Submit" NAME="fp_submit"><input TYPE="Reset" NAME="fp_reset"></td>
</tr>
</table>
</form>
<hr>
<!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside
tag="BODY"
local_preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="center"><font color="#000000">End of Database Results region.</font></td></tr></table>"
preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" i-CheckSum="62730" endspan -->
</body>
</html>
