Can'y get a new database to work

[Guest]

I can't believe I can't get a new database I have created to work. It's
driving me crazy. I have reviewed several other posts and think I am doing
everything correctly and yet I get the following error message every time I
try to establish a custom query in a form. My site is hosted by an ISP with
all FP extensions in place. I can add new records to the database but when I
create a search form, (insert, database, results) I use the same connection I
created in the original form that created the database. I select custom query
and type in one field name to search on. When I click VERIFY, I get the
following error msg.
Database Connection Error. The server encountered an error while processing
a database request. For more information click Details. I click Details and
get: Server error: Unable to retrieve schema info from the query: 1 Against a
database using the connection string DRIVER=(Microsoft Access
Driver(*.mdb));dbq=url=fpdb/newgroups.mdb. The following error msg comes from
the database software; (Microsoft)(odbcMicrosoft Access Driver) invalid SQL
statement; expected 'delete','insert','procedure','select, or'update'.
Source:Microsoft OLE DB provider for ODBC drivers.
Number:-2147217900(0x80040e14)
My website is maintained on my PC at home and I upload to the ISP through
FP2003. Website is www.linkintheworld.com. Click RGISTRATION Page to see the
search form.
Please help.
Regards,

 

[Bob Lehmann]

invalid SQL statement; expected 'delete','insert','procedure','select,
or'update'.

So, what does you SQL Statement look like?

Bob Lehmann

 

[Guest]

Hi Bob. Sorry it took me so long to get back to you. My SQL Statement looks
like this:
SELECT*FROMResults::City::
City is the field I want to search on. The error message now says
The Microsoft Jet database engine cannot find the input table or query
'Results1'. Make sure it exists and the name is spelled correctly.
Apparently it can't find the Results query because it's looking for
Results1. What am I doing wrong here?
Regards,

 

[Kathleen Anderson [MVP - FrontPage]]

RWS:
Your SQL statement should look like this:
SELECT * FROM Results WHERE (City = '::City::') if you have a search form
field on your page,
or,
SELECT * FROM Results WHERE (City = 'Hartford') if you have the search value
hard-coded.

See http://support.microsoft.com/kb/306430 for more information about the
SQL syntax that is generated by the FrontPage Database Results Wizard.

--

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

 

[Guest]

Hi Kathleen. Thanks for the reply. Your example of the correct syntax seems
to have solved my problem. Your link however for additional info about sql
syntax returnd a PAGE CANNOT BE FOUND response. Can you give me the correct
url. I would like to view other syntax examples by Microsoft.
Thank you in advance,
--
RWS FLorida

RWS:
Your SQL statement should look like this:
SELECT * FROM Results WHERE (City = '::City::') if you have a search form
field on your page,
or,
SELECT * FROM Results WHERE (City = 'Hartford') if you have the search value
hard-coded.

See http://support.microsoft.com/kb/306430 for more information about the
SQL syntax that is generated by the FrontPage Database Results Wizard.

--

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

 

[Kathleen Anderson [MVP - FrontPage]]

Try this link:
http://support.microsoft.com/default.aspx?scid=kb;en-us;306430

--

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