Well, for one, you don't need parens around the set fields, also a couple of your field names have "No" in the name, which I assume means number. You are adding these fields as if they are strings, so check that those fields are actually character and not number types in the database, and last, but definately not least, there is no where clause in this update statement. Do you really wish to update every row in the table with this information or did you want to only update a specific row?
Joined: Jan 08, 2006
No exceptions.. But the new data doesn't get updated