I want to update a record using sql server 2000. I had this script to work but suddenly I am getting a lot of strange errors.

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '55'.
/subliem/admin/product_edit.asp, line 111


line 111 : MM_editCmd.Execute


It is just the standard update behavior in dreamweaver, what could there be wrong ? It did work, and i didn't change anything.

Hmm.. I can't tell a cause from the error message. Are there any changes made to the database/table or SQL Server itself? What code do you have before line 111? And what would be a code syntax "near '55'"?

Things just don't go wrong without some changes, I suppose.

- Noz