Database Results Error

J

Jose Olivas

I get an error for a results page made by FP 2003 with an access 2003 DB.
The results page is from a query I created on Access and most all of my
other queries seem to be coming out fine.

Here is my message and code:

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


My code is as follows:

<tbody>

<!--webbot bot="DatabaseRegionStart"
s-columnnames="Name,SumOfPoints,RaceYear" s-columntypes="202,5,2"
s-dataconnection="prestigePoints" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="TRUE" s-recordsource="2004 Standings"
s-displaycolumns="Name,SumOfPoints,RaceYear" s-criteria s-order
s-sql="SELECT * FROM &quot;2004 Standings&quot;" b-procedure="FALSE"
clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records
returned." i-maxrecords="256" i-groupsize="5" botid="0"
u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" startspan
preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot;
width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the
start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" --><!--#include
file="_fpclass/fpdblib.inc"-->
<% 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 ""2004 Standings"""
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=3 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="prestigePoints"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Name=202&SumOfPoints=5&RaceYear=2&"
fp_iDisplayCols=3
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="40214" -->

<tr>

<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,SumOfPoints,RaceYear" s-column="Name"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Name&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Name")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="3900" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,SumOfPoints,RaceYear" s-column="SumOfPoints"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;SumOfPoints&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"SumOfPoints")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="33403" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,SumOfPoints,RaceYear" s-column="RaceYear"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;RaceYear&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"RaceYear")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="15055" -->
</td>


</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5"
clientside tag="TBODY" startspan preview="&lt;tr&gt;&lt;td colspan=64
bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD VALIGN=MIDDLE
COLSPAN=64&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot; |&lt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt; &quot;&gt;&lt;INPUT
TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT TYPE=Button
VALUE=&quot; &gt;| &quot;&gt;
[1/5]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;" --><!--#include
file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" -->
</tbody>

</table>
 
J

Jim Cheshire

Jose said:
I get an error for a results page made by FP 2003 with an access 2003
DB. The results page is from a query I created on Access and most all
of my other queries seem to be coming out fine.

s-sql="SELECT * FROM &quot;2004 Standings&quot;" b-procedure="FALSE"
Click to expand...


Did you put quotes around the table name like that? You shouldn't have
quotes there I don't think. Try enclosing the table name inside of square
brakets.

--
Jim Cheshire
JIMCO
http://www.jimcoaddins.com
Free add-ins for FrontPage

Author of Special Edition
Using Microsoft Office FrontPage 2003
 
T

Tom

Redo it!

Take the spaces out of your table names, if you MUST have a space, your
going to have problems! Consider using a mix of cases or underscores.

2004Standings or 2004_Standings



Jose Olivas said:
I get an error for a results page made by FP 2003 with an access 2003 DB.
The results page is from a query I created on Access and most all of my
other queries seem to be coming out fine.

Here is my message and code:

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


My code is as follows:

<tbody>

<!--webbot bot="DatabaseRegionStart"
s-columnnames="Name,SumOfPoints,RaceYear" s-columntypes="202,5,2"
s-dataconnection="prestigePoints" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="TRUE" s-recordsource="2004 Standings"
s-displaycolumns="Name,SumOfPoints,RaceYear" s-criteria s-order
s-sql="SELECT * FROM "2004 Standings"" b-procedure="FALSE"
clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records
returned." i-maxrecords="256" i-groupsize="5" botid="0"
u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" startspan
preview="<tr><td colspan=64 bgcolor="#FFFF00"
width="100%"><font color="#000000">This is the
start of a Database Results
region.</font></td></tr>" --><!--#include
file="_fpclass/fpdblib.inc"-->
<% 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 ""2004 Standings"""
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=3 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="prestigePoints"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Name=202&SumOfPoints=5&RaceYear=2&"
fp_iDisplayCols=3
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="40214" -->

<tr>

<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,SumOfPoints,RaceYear" s-column="Name"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="&lt;font
size="-1">&lt;&lt;</font>Name<font
size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"Name")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="3900" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,SumOfPoints,RaceYear" s-column="SumOfPoints"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>SumOfPoints<font
size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"SumOfPoints")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="33403" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,SumOfPoints,RaceYear" s-column="RaceYear"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>RaceYear<font
size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"RaceYear")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="15055" -->
</td>


</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5"
clientside tag="TBODY" startspan preview="<tr><td colspan=64
bgcolor="#FFFF00" width="100%"><font
color="#000000">This is the end of a Database Results
region.</font></td></tr><TR><TD VALIGN=MIDDLE
COLSPAN=64><NOBR><INPUT TYPE=Button VALUE=" |<
"><INPUT TYPE=Button VALUE=" < "><INPUT
TYPE=Button VALUE=" > "><INPUT TYPE=Button
VALUE=" >| ">
[1/5]</NOBR><BR></td></tr>" --><!--#include
file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" -->
</tbody>

</table>
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database Results Wizard Error - FrontPage 2003 5
I am trying to understand this code... 3
FP2003 SQL ignoring values passed through hyperlink 2
bullet list extra spacing 2
any ideas why I can update one table in my database but not the other? 2
webbot bot="DatabaseRegionStart 5
UPDATE database problems 0
@ my wits end 1

Top