Microsoft KB Archive/206091

= 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           | My Message                         |
 * Center              | My Message                 |
 * Hyperlink           | My Message           |
 * Hyperlink and Center | My Message" |

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