You receive an "Unable to find operator in query string" error message when you use the ORDER BY parameter in a custom SQL query in FrontPage 2003

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article has been archived. It is offered "as is" and will no longer be updated.
SYMPTOMS
When you use the ORDER BY parameter in a custom SQL query in the Database Results Wizard in Microsoft Office FrontPage 2003, you receive the following error message:
Unable to find operator in query string. Query string currently is SELECT * FROM Employees ORDER BY ::SortField::
RESOLUTION
This problem was first fixed in a hotfix that is now contained in a service pack. If you installed the latest Office 2003 service pack, you do not have to install the hotfix.

Service pack information

This problem is corrected in Office 2003 Service Pack 2.

To resolve this problem, obtain the latest service pack for Office 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
870924 How to obtain the latest service pack for Office 2003

Hotfix information

How to obtain the hotfix

This issue is fixed in the FrontPage 2003 post-Service Pack 1 Hotfix Package that was released on October 4, 2004. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
886758 Description of the FrontPage 2003 post-Service Pack 1 hotfix package: October 4, 2004

Note This hotfix resolves the specific issue of using the ORDER BY parameter in a custom SQL query. FrontPage 2003 will not support other parameters even after the installation of this hotfix.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

This problem was first corrected in Office 2003 Service Pack 2.
frontpage2003 fp2003 sql
Properties

Article ID: 871267 - Last Review: 01/15/2015 00:55:58 - Revision: 4.3

  • Microsoft Office FrontPage 2003
  • kbnosurvey kbarchive kbqfe kboffice2003sp2fix kbasp kberrmsg kboffice2003presp2fix kbbug kbfix KB871267
Feedback