|
| |
|
|
Eli
Posts: 2659
From: ... er ...
Status: offline
 |
updating database - 1/17/2002 10:27:13
I'm updating a database using a web form & custom query:
I got this error returned, anyone know what it means and how I can fix it:
Database Results Error: mismatched parameter delimiters
thanx
"... treat me like a child.."
|
|
|
|
Mojo
Posts: 2441
From: Chicago
Status: offline
|
RE: updating database - 1/17/2002 12:39:47
Could you post your SQL statement?
Joe
| |
|
|
|
Eli
Posts: 2659
From: ... er ...
Status: offline
|
RE: updating database - 1/17/2002 13:57:23
UPDATE Attractions
SET
Name='::Name::',
City='::City::',
County='::County::',
Area='::Area::',
Description='::Description::',
EmailName='::Email Name::',
Email='::Email::',
WebSiteName='::Web Site Name::',
WebSite='::Web Site::',
moredescription='::moredescription::',
moredescription2='::moredescription2::',
moredescription3='::moredescription3::',
Phone='::Phone::',
Photo='::Photo::',
Reviewwrite='::Review Write::',
visitorcomments='::Visitor Comments::',
comments='::Comments::',
map='::Map::',
family='::Family::',
Facilities=':: Facilities::',
Education='::Education::',
Relaxing='::Relaxing::',
fun='::Fun::',
where2stay='::where2stay::'
WHERE ID= ::ID
"... treat me like a child.."
| |
|
|
|
ginnie
Posts: 527
From: St. Louis MO USA
Status: offline
|
RE: updating database - 1/17/2002 15:11:09
Hi Micah,
I'm not sure about that particular error message, but "Name" is a reserved word and either shouldn't be used at all for a field name or should be surrounded by brackets in your queries:
Set [Name] = '::Name::'
ginnie
Global Presence Web Design
| |
|
|
|
I_M_Spartacus
Posts: 3
Joined: 1/10/2002
From:
Status: offline
|
RE: updating database - 1/18/2002 15:58:24
Do you need :: after the last ID?? This is not a suggestion. I'm just wondering. Thanx
| |
|
 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 
