Hi Thomas
Line 49 is (I believe) fp_sNoRecords="<tr><td colspan=1 align=""LEFT""
width=""100%"">No records
Below is the full code.
Thanks
John
<html>
<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Field1</title>
</head>
<body>
<p> </p>
<p> </p>
<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>ClubName</b></th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-columnnames="ClubName"
s-columntypes="202" s-dataconnection="asptest" b-tableformat="TRUE"
b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE"
b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"
b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE"
s-recordsource="qry_clubs" s-displaycolumns="ClubName" s-criteria s-order
s-sql="SELECT * FROM qry_clubs" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields s-norecordsfound="No records returned."
i-maxrecords="256" i-groupsize="0" botid="0" u-dblib="_fpclass/fpdblib.inc"
u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY"
preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><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>"
startspan -->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM qry_clubs"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=1 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="asptest"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ClubName=202&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan --><tr>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ClubName"
s-column="ClubName" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1"><<</font>ClubName<font
size="-1">>></font>" startspan
--><%=FP_FieldVal(fp_rs,"ClubName")%><!--webbot bot="DatabaseResultColumn"
endspan --></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00"
width="100%"><font color="#000000">This is the end of a Database Results
region.</font></td></tr>" startspan -->
<!--webbot bot="DatabaseRegionEnd" endspan --></tbody>
</table>
</body>
</html>
