statement error

S

Stacy

can someone tell what's wrong with this query statement

UPDATE Results SET Project_Status = '::project_Status::' , Dns_Status =
'::Dns_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::)
 
T

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.
==============================================
 
S

Stacy

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.
 
S

Stacy

ok now this statement works

UPDATE Results SET Project_Status = '::project_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?

Stacy said:
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)


Thomas A. Rowe said:
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
 

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

Top