|
Eli -> updating records problem (12/11/2001 7:55:03)
|
hi! I'm writing an update records page as outlines at http://www.sitebuilder.ws/frontpage/tutorials/update.htm (i know that some of you are familiar wu=ith this)
I'm getting this error when a try and validate in FP: 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)
The sql statement is as follows:
UPDATE bios
SET Name='::Name::', Town='::Town::',County='::County::', Area='::Area::', Roomrate='::Room Rate::', Description= '::Description::', Rating='::Rating::', SendEmail='::Send Email::', Email='::Email::', VisitWebSite= '::Visit Web Site::', Web= '::Web::', Dogs= '::Dogs::', Children= '::Children::', licensed= '::licensed::', Garden= '::Garden::', nonsmoking= '::non-smoking::', pool='::pool::', parking='::parking::', phone='::phone::', leisuresuite= '::leisure-suite::', photo= '::photo::', map='::review::', availability= '::availability::', place2visit= '::place2visit::',
WHERE ID= ::ID::
anyone spot the problem?
many thanks!
"... treat me like a child.."
|
|
|
|
