SYNTAX Error

SYNTAX Error (Full Version)

All Forums >> [Web Development] >> ASP and Database

Message

leehintz -> 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::)

Spooky -> 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

Page: [1]

0.03125