FP97: Maximum Number of Data Rows Fetched Incorrect in IDC Query

 Last reviewed: March 18, 1998
Article ID: Q176932
The information in this article applies to:
  • Microsoft FrontPage 97 for Windows with Bonus Pack

SYMPTOMS

The results of an IDC query may be incorrect when you run a query on the Microsoft Personal Web Server (MSPWS) for Windows 95 even though you selected the "Maximum number of rows fetched" option and specified a limit to the number of rows to be returned.

To locate the "Maximum number of rows fetched" option, double-click the .idc file, click Advanced Options in the Internet Database Connector Wizard, and then click the Limits tab.

CAUSE

This problem occurs because the IDC Wizard places the MaxRecords entry after the SQL string rather than before the SQL string in the IDC file it creates. Therefore, since the MSPWS evaluates the file from top to bottom in only one pass, the SQL query is executed before the MaxRecords statement is evaluated.

RESOLUTION

Open the .idc file in a text editor such as Notepad, and move the MaxRecords entry so that it appears above the SQL statement.

Microsoft Technical Support will not resolve problems produced by editing the HTML that FrontPage generates. For more information about writing HTML, please see the following Microsoft Web site: 

   http://www.microsoft.com/workshop/author/newhtml/default.htm.
NOTE: Because the Microsoft Web site is constantly updated, the site address may change without notice. If this occurs, link to the Microsoft home page at the following address: 

   http://www.microsoft.com

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft FrontPage 98.

Additional query words: 97 IDC MaxRecords wizard fpodbc
Keywords : kbdta
Version : WINDOWS:97
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.