FP98: How to Remove or Customize "No Records Returned" Message

Last reviewed: March 18, 1998
Article ID: Q182122

The information in this article applies to:

Microsoft FrontPage 98 for Windows

SUMMARY

If you use an insert query in your database region, you may receive the following message when you open your page in a Web browser:

   No Records Returned.

This article describes how to customize or remove this message.

MORE INFORMATION

Microsoft Technical Support will not resolve problems produced by editing the HTML that FrontPage generates. This HTML code sample is provided as a convenience for authors seeking to extend the capabilities of FrontPage. For more information about writing HTML, please see the following Microsoft Web site:

   http://www.microsoft.com/workshop/author/newhtml/default.htm

WARNING: ANY USE BY YOU OF THE HTML PROVIDED IN THIS ARTICLE IS AT YOUR OWN RISK. Microsoft provides this HTML "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

To customize the message returned from the Database Region Wizard, start or switch to FrontPage Explorer and follow these steps:

Open your Web. On the View menu, click Folders.
Right-click the ASP page you want to modify. Click Open With on the menu that appears.
In the Open With Editor dialog box, select "Text Editor (notepad.exe)" and click OK.
Find the following line:
```
      fp_sNoRecords = "No Records Returned"
```
NOTE: The text between the quotation marks (in this example, "No Records Returned"), is the message that appears if no records are returned from the query.
Replace the text enclosed in quotation marks with the message you want to be displayed, like this:
```
      fp_sNoRecords = "This is My Message"
```
If you do not want any message to be displayed, delete the text between the quotation marks, so that it looks like this:
```
      fp_sNoRecords = ""
```
On the File menu, click Save.
On the File menu, click Exit.

NOTE: Each time you save the page in FrontPage Editor, any changes you made to this script will be overwritten. If that happens, you will need to follow these steps again to restore your changes.

ADDITIONAL INFORMATION

You can format the message text by inserting standard HyperText Markup Language tags in the asp file. Following are some examples.

   To Apply this Format     Edit the Text String like this
   ----------------------------------------------------------------------------

   Heading 1                fp_sNoRecords = "<H1>My Message</H1>"

   Center                   fp_sNoRecords = "<CENTER>My Message</CENTER>

   Hyperlink                fp_sNoRecords = "<A href="link.htm">My Message</A>"

   Hyperlink and Center     fp_sNoRecords = "<CENTER><A href="link.htm">My
                                             Message</A></CENTER>"

Additional query words: 98 asp database vbscript html
Keywords : fpedit fphtml fpscript fpactive kbdta
Component : jet
Technology : internet kbinetdev odbc
Version : WINDOWS:98
Platform : WINDOWS
Hardware : x86
Issue type : kbhowto

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 18, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.