|
| |
|
|
Eli
Posts: 2658
From: ... er ...
Status: offline
 |
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.."
|
|
|
|
xterradane
Posts: 143
From: Mobile, AL USA
Status: offline
|
RE: updating records problem - 12/11/2001 8:56:23
try taking the comma off the end of place2 visit: lastplace2visit= '::place2visit::',
So it will be: place2visit= '::place2visit::' WHERE ID....
That should work...
| |
|
|
|
Eli
Posts: 2658
From: ... er ...
Status: offline
|
RE: updating records problem - 12/11/2001 9:28:14
yey - it works!
thanks!!!!
"... treat me like a child.."
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
