FP2000: "No Records Returned" Received When Posting to Database

Article ID: Q206091

The information in this article applies to:

Microsoft FrontPage 2000

SYMPTOMS

In Microsoft FrontPage, when you use the INSERT INTO Structured Query Language (SQL) command with the Database Region Wizard, you may receive the following message when you open the Active Server Page (ASP) in a Web browser:

   No Records Returned.

CAUSE

The Database Results Wizard defaults to the SELECT SQL statement rather than the INSERT INTO SQL statement. When you run the Database Region Wizard, FrontPage assumes you are trying to use a SELECT statement. Because it does not find the data that was specified, you will receive the message described in the "Symptoms" section.

RESOLUTION

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/c-frame.htm#/workshop/author/default.asp

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 Results Wizard, start or switch to FrontPage and follow these steps:

1. In the Page view of FrontPage, open the ASP page that you want to modify.

2. Right-click the Database Region and select Database Results Properties

3. Click Next.

4. Click Next again.

5. In Step Three of the Database Results Wizard, Click More Options.

6. In the box labeled "Message to display if no records are returned:" Type the

   desired message you would like to return

7. Click OK.

8. Click Next Twice.

9. Click Finish.

10. Save the Page.

ADDITIONAL INFORMATION

You can format the message text by inserting standard HyperText Markup Language tags in the asp file. Some examples are listed in the following table.

+--------------------------------------------------------------------+
| To apply this format | Edit the text string as follows             | 
+--------------------------------------------------------------------+
| Heading 1            | <H1>My Message</H1>                         | 
+--------------------------------------------------------------------+
| Center               | <CENTER>My Message</CENTER>                 | 
+--------------------------------------------------------------------+
| Hyperlink            | <A href="link.htm">My Message</A>           | 
+--------------------------------------------------------------------+
| Hyperlink and Center | <A href="link.htm">My Message</A></CENTER>" | 
+--------------------------------------------------------------------+

MORE INFORMATION

For additional information about Active Server Pages, please see the following article(s) in the Microsoft Knowledge Base:

   Q207149 FP2000: How to Post Information to a Database Using ASP

Additional query words: fpeditor iis asp vbscript fpodbc front page 2000RTMPublic

Keywords          : kbdta fpedit fpiis 
Version           : WINDOWS:
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbprb