Can you help me with my SQL statement?

[Ryratt]

I have looked and looked at this statement and it looks the same as my other one in my other ASP script that works, but i keep getting "Syntax Error in Update statement"

Just want to know if you guys can see anything obvious because I have been going over it for 2 days.

UPDATE contactus SET name = 'Wag & Pal', address = '21 Chicago Avenue, Suite 305', city = 'Riverside', state = 'CA', zip = '92507', phone = '(951) 888-8888', fax = '9090909', email = 'emailaddress', memo = 'This is the memo field that can go next to the contact info' WHERE (ID = 1)

ANyway, this is exactly what is going into a variable that goes into the commandText property. I tried it with the parenthesis around ID = 1 and without them.

(I edited the personal info for the record)

[[Sx]]

try:

UPDATE `contactus` SET `name`='Wag & Pal', `address`='21 Chicago Avenue, Suite 305', `city`='Riverside', `state`='CA', `zip`='92507', `phone`='(951) 888-8888', `fax`='9090909', `email`='emailaddress', `memo`='This is the memo field that can go next to the contact info' WHERE `ID`='1';

And make sure that none of the entries contains unescaped ' character...

[Ryratt]

sorry that didn't work either.

UPDATE `contactus` SET `name` = 'Wagyes', `address` = '21 Chicago Avenue, Suite 305', `city = 'Riverside', `state` = 'CA', `zip` = '92507', `phone` = '(951) 888-8888', `fax` = '9090909', `email` = 'emailaddress', `memo` = 'This is the memo field that can go next to the contact info' WHERE `ID` = '1'

Microsoft JET Database Engine error '80040e14'

Syntax error in UPDATE statement

[Xeef]

if this is copy&Pasete

here is one ERROR (mayby more !?)

Suite 305', `city = 'Riverside'

[Ryratt]

Yeah I saw that earlier and fixed it and it still didn't work, but I figured out what did...

For some reason, I wrapped the table names and feild names in [ ] and it worked. Like I said, I had my original exact method on another ASP page with no [ ] and it worked.... I get upset when computers aren't logical...

UPDATE [contactus] SET [name] = 'Wa & Pel', [address] = '21 Chicago Avenue, Suite 305', [city] = 'Riverside', [state] = 'CA', [zip] = '92507', [phone] = '(951) 888-8888', [fax] = '9090909', [email] = 'emailaddress', [memo] = 'This is the memo field that can go next to the contact info' WHERE [ID] = 1