Microsoft KB Archive/177082

-

{| The information in this article applies to:
 * width="100%"|
 * 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
 * }

-

Last reviewed: November 18, 1998

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.