statement error

[Guest]

can someone tell what's wrong with this query statement

UPDATE Results SET Project_Status = ':roject_Status::' , Dns_Status =
':ns_Status::' , WebSite_Name = '::WebSite_Name::' , Comments =
'::Comments::' , staff_name = '::staff_name::' , Location = '::Location::' ,
Remote_computer_name = '::Remote_computer_name::' , User_name =
'::User_name::' , Browser_type = '::Browser_type::' , Timestamp =
'::Timestamp::' WHERE (ID = ::ID:

 

[Thomas A. Rowe]

What is the actual error message?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Guest]

The server encountered an error while processing a database request.

Server error: Unable to retrieve schema information from the query:

UPDATE Results SET Project_Status = '1' , dns_Status = '2' , website_name=
'3' , staff_name='4' , location='5' , Remote_computer_name='6' ,
User_name='7' , Browser_type='8' , Timestamp='9' WHERE (ID = 10)

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/projects.mdb.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.

 

[Guest]

ok now this statement works

UPDATE Results SET Project_Status = ':roject_Status::' , dns_Status =
'::dns_status::' , website_name= '::website_name::' ,
staff_name='::staff_name::' , location='::location::' ,
Remote_computer_name='::Remote_computer_name::' , User_name='::User_name::' ,
Browser_type='::Browser_type::' WHERE (ID = ::ID:

I took out the timestamp. but when viewed in a browser i get this

Your page contains a query with user input parameters that could not be
resolved.
This could happen if your DatabaseRegionStart webbot has an empty or missing
s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.

I think i already made changes to the DatabaseRegionStart region. unless
it's because i left out the timestamp part which seems to cause problems. So
now what?

The server encountered an error while processing a database request.

Server error: Unable to retrieve schema information from the query:

UPDATE Results SET Project_Status = '1' , dns_Status = '2' , website_name=
'3' , staff_name='4' , location='5' , Remote_computer_name='6' ,
User_name='7' , Browser_type='8' , Timestamp='9' WHERE (ID = 10)

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/projects.mdb.

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)

What is the actual error message?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp