Database wizard problems

A

annaMac

Using the database Results wizard in Frontpage I have set up a database
editor page but get a database connection error when I verify the criteria:
Server error: Unable to retrieve schema information from the query:

UPDATE Results SET Sector = '1' , Company = '2' , Contact = '3' , Website =
'4' , Email = '5' , Telephone = '6' , Address = '7' , Position = '8' , Area =
'9' , Salary = '10' , Per = '11' , Description = '12' , Remote_computer_name
= '13' , Timestamp = '14' , Ref = '15' , subject = '16' , User_name = '17' ,
Browser_type = '18' WHERE (ID = 19)


The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

This is the SQL statement:


UPDATE Results SET Sector = '::Sector::' , Company = '::Company::' , Contact
= '::Contact::' , Website = '::Website::' , Email = '::Email::' , Telephone =
'::Telephone::' , Address = '::Address::' , Position = '::position::' , Area
= '::Area::' , Salary = '::Salary::' , Per = '::per::' , Description =
'::Description::' , Remote_computer_name = '::Remote_computer_name::' ,
Timestamp = '::Timestamp::' , Ref = '::Ref::' , subject = '::subject::' ,
User_name = '::User_name::' , Browser_type = '::Browser_type::' WHERE (ID =
::ID::)

I would appreciate your help!

Anna Mac
 
A

annaMac

Kathleen, its 2003 with service pack 2 . I have solved the problem though,
thanks - Timestamp is a reserved name so I just had to bracket it and then
set any empty fields to zero length. It works fine now.

Kathleen Anderson said:
Anna Mac:
What version of FrontPage are you running? If FP2003, have you applied all
Office Service Packs?

--

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




annaMac said:
Using the database Results wizard in Frontpage I have set up a database
editor page but get a database connection error when I verify the
criteria:
Server error: Unable to retrieve schema information from the query:

UPDATE Results SET Sector = '1' , Company = '2' , Contact = '3' , Website
=
'4' , Email = '5' , Telephone = '6' , Address = '7' , Position = '8' ,
Area =
'9' , Salary = '10' , Per = '11' , Description = '12' ,
Remote_computer_name
= '13' , Timestamp = '14' , Ref = '15' , subject = '16' , User_name = '17'
,
Browser_type = '18' WHERE (ID = 19)


The following error message comes from the database driver software; it
may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE
statement.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

This is the SQL statement:


UPDATE Results SET Sector = '::Sector::' , Company = '::Company::' ,
Contact
= '::Contact::' , Website = '::Website::' , Email = '::Email::' ,
Telephone =
'::Telephone::' , Address = '::Address::' , Position = '::position::' ,
Area
= '::Area::' , Salary = '::Salary::' , Per = '::per::' , Description =
'::Description::' , Remote_computer_name = '::Remote_computer_name::' ,
Timestamp = '::Timestamp::' , Ref = '::Ref::' , subject = '::subject::' ,
User_name = '::User_name::' , Browser_type = '::Browser_type::' WHERE (ID
=
::ID::)

I would appreciate your help!

Anna Mac
 

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


Top