DB Error-Incomplete query clause

[Greg]

i dont recall ever making any changes to a site i have
but now im getting this error on a DB results area on teh
website...

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

ive triplechecked everything and cant find any problems.
what is this error saying? thanks!

 

[Kathleen Anderson [MVP - FP]]

What does your SQL look like? Have you checked with your host to see if they
made any changes at their end?

 

[Greg]

i havent been able to get in touch with them but im
doubting its that being that i have another DB Results
part that works fine and the setup is identical except
for the info in the DB. even tried to recreate the
results page and getting the same error. as for SQL, i
dont have anything custom or added to what the wizard
creates for these parts.

 

[Kathleen Anderson \(MVP - FrontPage\)]

What is the SQL that the wizard created? Can you post it here?

--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/