SYNTAX Error

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

SYNTAX Error

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> SYNTAX Error

Page: [1]


leehintz Posts: 383 Joined: 10/10/2000 From: Oak Creek Wisconsin USA Status: offline	SYNTAX Error - 10/29/2007 22:04:52 Hi Again, I am getting the SYNTAX Error that I have seen in a lot of posts. Can anyone tell me what to change in my code in my update records DRW Custom Query? Thanks! UPDATE c-gagl SET Name = '::Name::' , Organization = '::Organization::' , Contact = '::Contact::' , Email='::Email::', Status = '::Status::' , Events='::Events::', Message='::Message::', Photo = '::Photo::' , URL = '::URL::' WHERE (ID = ::ID::) _____________________________ Lee A. Hintz, Consultant ArtGals.com www.artgals.com

Spooky

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

RE: SYNTAX Error - 10/29/2007 22:11:36

UPDATE [c-gagl] SET [Name] = '::Name::' , Organization = '::Organization::' , Contact = '::Contact::' , Email='::Email::', Status = '::Status::' , Events='::Events::', Message='::Message::', Photo = '::Photo::' , URL = '::URL::' WHERE (ID = ::ID::)

Name is a reserved word

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

��k�

Database / DRW help Check out the Tutorials for Frontpage Databases

Forum FAQ' s

Developers Edition Spooky Login User Registration and Management tool

Personalized Frontpage Hosting

(in reply to leehintz)