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 = ':osition::' , Area
= '::Area::' , Salary = '::Salary::' , Per = ':er::' , Description =
':escription::' , 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
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 = ':osition::' , Area
= '::Area::' , Salary = '::Salary::' , Per = ':er::' , Description =
':escription::' , 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