ASP Question

[Nicole]

We have completed a clean install of Microsoft Server 2003
on our Web Server and are using frontpage 2002 for our web
site. On our asp page (www.dgf.k12.mn.us/contactus.asp) we
are getting the following error:

Database Results Error
Description: Syntax error in query. Incomplete query
clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
www.dgf.k12.mn.us/contactus.asp

We cannot find any kind of documentation on this error.
Has anyone else seen this kind of error, and know how to
fix it?

thanks for the help


Nicole

 

[Jim Buyens]

-----Original Message-----

We have completed a clean install of Microsoft Server
2003 on our Web Server and are using frontpage 2002 for
our web site. On our asp page
www.dgf.k12.mn.us/contactus.asp) we are getting the
following error:

Database Results Error
Description: Syntax error in query. Incomplete query
clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
www.dgf.k12.mn.us/contactus.asp

We cannot find any kind of documentation on this error.
Has anyone else seen this kind of error, and know how to
fix it?

The SQL statement that retrieves the data for your
Database Results Region has an error.

Opening the page in its new location and rerunning the
wizard may fix the problem.

The same message can occur when you set criteria based on
form field input, and the field contains no data. The fix
in this case is usually to set a default value. (On page 3
of the wizard, click More Options, Defaults.

It's also possible that a custom query you specified from
page 2 of the wizard is malformed. In this case, you must
fix the SQL code yourself.

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*