No Records

[L]

Is it possible for the No Records found message to be displayed after the
user clicks the submit button. Currently, when I load the page, the message
appears.
Below is the code that I am using:
<%
fp_sQry="SELECT * FROM tblCompany WHERE (Password = '::txtPassword::' AND
Username = '::txtUsername::')"
fp_sDefault="txtPassword=isisvar&txtUsername=isis9009"
fp_sNoRecords="No Records"
fp_sDataConn="VAR_Admin"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue="
fp_sColTypes="&CompanyID=3&CompanyName=202&ContactName=202&ContactAddress=202&ContactCity=202&ContactState=202&ContactZip=202&ContactPhone=202&ContactEmail=202&ContactURL=203&Username=202&Password=202&"
fp_iDisplayCols=3
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

 

[Jim Buyens]

You would have to create an intial page that displays the form but not
database region.
That page would have the same form fields with the same form field names,
and it would name the DRW page in the form's action= property.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------

 

[Kathleen Anderson [MVP - FrontPage]]

Try this:
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/