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

Last reviewed: November 18, 1998
Article ID: Q177082

The information in this article applies to:

Microsoft FrontPage 98 for Windows

SYMPTOMS

In Microsoft FrontPage 98, 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 Microsoft FrontPage 98 Database Region Wizard supports 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 and because it does not find the data that was specified, you will receive the message described in the "Symptoms" section.

RESOLUTION

To use advanced database queries with ASP, create a custom script by using Visual Basic Scripting Edition (VBScript) or JScript that will perform these SQL queries.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

For additional information, please see the following articles in the Microsoft Knowledge Base:

   ARTICLE-ID: Q175770
   TITLE     : FP98: How to Post Information to a Database Using ASP

   ARTICLE-ID: Q182122
   TITLE     :FP98: How to Remove or Customize 'No Records Returned' 
              Message

Additional query words: fpeditor iis asp vbscript fpodbc
Keywords : kbdta fpedit fpiis
Version : WINDOWS:98
Platform : WINDOWS
Hardware : x86
Issue type : kbprb

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.