Suppressing the "No Records Returned" message

P

Paul

How can I keep the "No Records Returned" message from
displaying in a database results table? I have a page
with many database results fields, but there will never
be a case when all of them should be active. Based on
changes made to a database, I want the page to
dynamically activate only those database results tables
that have data to display. For the others, when there
are no records that meet the criteria, I don't want the
page to have any sign that a table of information could
be displayed in that spot under other conditions.

I can't figure out how to make nothing happen when no
records are returned. Do I need to create an ASP "If
Then" statement that checks to see if there are any
records that meet the criteria, and skips all the lines
of Database Results code if the answer is no? Does
anyone know the syntax for this, or do you have other
suggestions? Thanks!
 
J

Jim Buyens

-----Original Message-----
How can I keep the "No Records Returned" message from
displaying in a database results table? I have a page
with many database results fields, but there will never
be a case when all of them should be active. Based on
changes made to a database, I want the page to
dynamically activate only those database results tables
that have data to display. For the others, when there
are no records that meet the criteria, I don't want the
page to have any sign that a table of information could
be displayed in that spot under other conditions.

I can't figure out how to make nothing happen when no
records are returned. Do I need to create an ASP "If
Then" statement that checks to see if there are any
records that meet the criteria, and skips all the lines
of Database Results code if the answer is no? Does
anyone know the syntax for this, or do you have other
suggestions? Thanks!
Click to expand...

On page 3 of the Wizard, click More Options and replace
the contents of the Message To Display If No Records Are
Returned text box with a space.

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

grw

The best option, is to place your query form on a page seperate from the
DRW.
It can be an html or asp page, doesnt matter.

POST it to the page containing the DRW and the query will be processed.
Ensure "Use this search form" at step 3 > more options and DONT check add
search form at step 5
 
Top