FP97: Syntax Error If Query Contains Parameter Values (159435)
The information in this article applies to:
- Microsoft FrontPage 97 for Windows with Bonus Pack
This article was previously published under Q159435 SYMPTOMS
When you use a query containing parameter values generated by the
Internet Database Connector Wizard, the ODBC driver may return a
syntax error in the query expression.
CAUSE
There are many possible causes for syntax errors in ODBC queries. If
the parameter value you specified contains text, check to make sure
the parameter is enclosed in single quotation marks. The FrontPage
Database Connector Wizard doesn't insert single quotation marks around
parameter values.
RESOLUTION
When you specify a parameter in an SQL statement that will contain
text, enclose the parameter in single quotation marks.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed
at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 10/1/2002 |
---|
Keywords: | kbnetwork kbprb KB159435 |
---|
|