Access Database/FrontPage Display error

Paul Schandel · Aug 4, 2003

While trying to create a basic FrontPage page to display the information
from my access database I get this error:

Database Results Error
Description: Syntax error in query. Incomplete query clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

One or more form fields were empty. You should provide default values for
all form fields that are used in the query.

Now, I am only using 2 fields from the database. The ID number, and a
hostname associated with that hostname. If an particular ID number has an
unknown hostname at this time the field is inputed with a question mark. So
in this fashion both fields are completely populated. But I still get this
error.

Where else should I be looking?

Any help greatly appreciated.

Paul Schandel · Aug 4, 2003

Well this doesnt seem to have any effect on it either.

As I limited it to just the ID numbers in the search and I still got the
same error.

This is beginning to drive me batty. It does appear that the student who
created this database, put spaces in his table names, and left some entries
blank through out the table.

I am on trying to get 2 fields to display from the entire databas thought
the ID record number and the hostname of a machines.

but i noticed the web bot code made reference to ever field in the table.
Will this cause a problem?

Paul Schandel · Aug 4, 2003

As another test.

I created a whole new test database. With new simple table names and test
data. There were a total of 5 fields. All populated with data.

I cannot get it to just list out the data without getting the same error
knowing there are at this time no spaces or otherwise in the page but still
get the following error:

Database Results Error
Description: Syntax error in query. Incomplete query clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

thanks...

Paul Schandel · Aug 4, 2003

here is a direct cut and paste of the code the frontpage creates using the
DRW.

<table width="100%" border="1">
<thead>
<tr>
<td><b>ID</b></td>
<td><b>HostName</b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""DR Book"""
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="DR-TEST"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<td><a href="display.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>">
<%=FP_FieldVal(fp_rs,"ID")%></a></td>
<td>
<%=FP_FieldVal(fp_rs,"HostName")%></td>
</tr>

</tbody>
</table>

</body>

</html>

--
Thanks
Paul Schandel

------------------
http://www.get-me-home.org

Thomas A. Rowe said:
Please show us the query statement you are using.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

Paul Schandel said:

As another test.

I created a whole new test database. With new simple table names and test
data. There were a total of 5 fields. All populated with data.

I cannot get it to just list out the data without getting the same error
knowing there are at this time no spaces or otherwise in the page but still
get the following error:

Database Results Error
Description: Syntax error in query. Incomplete query clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

thanks...

Click to expand...

has

Thomas A. Rowe · Aug 4, 2003

I don't work with the FP database component, so someone else will need to
help you. However, remove all spaces from your tables and field names might
help.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

Jim Buyens · Aug 5, 2003

Paul Schandel said:
here is a direct cut and paste of the code the frontpage creates using the
DRW.

I spent a bit of time trying to test this code. This was difficult
because I don't have a copy of the database. I tried to create a test
database with all the same file, table and field names and ran into
various problems, but not, "Syntax error in query. Incomplete query
clause."

My recommendation is this: rename the Access file name, the database
connection name, the table name, and all the field names. Assign new
names that consist of numbers and letters only, with the first
character being a letter.

Then, delete your database region and create a new one from scratch.

I realize that this is pretty drastic, and that you'd probably prefer
a point fix. But spaces, hyphens, and special characters in general
require special treatment in SQL statements, and that treatment varies
by database system. Your database results region might work perfectly
well "as is" with a SQL Server database, for example.

FrontPage doesn't handle all these nuances well and messages like
"Syntax error in Query" often result. So, the best solution is
generally to use simple names throughout and avoid the need for
treatment of special characters.

If this advice doesn't provide a solution, please send me the
offending asp and mdb files by e-mail.

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) ||
|/----------------------------------------------------\|
*------------------------------------------------------*