SQL update help (1 Viewer)

[dastonecutters]

hey people could someone help me with this SQL string

it says there is a syntax error

("UPDATE PersonInfo SET (FirstName = '{1}'), (PhoneNum = '{2}'), (Number = '{3}'), (Adress = '{4}'), (Suburb = '{5}'), (Postcode = '{6}') Where (LastName = '{0}')", LastName, FirstName, PhoneNum, Number, Adress, Suburb, PostCode)

its all spelt properly and the connection to the db is correct

 

[sunny]

What are you using this SQL in? Could you describe your environment abit more?

 

[dastonecutters]

vb.net and using it in an aspx webpage

 

[sunny]

I don't know how exactly you are using this or how the database is set up, so I'll just give suggestions;

Have you tried a smaller query to see if it works? Something just along the lines of "UPDATE PersonInfo SET Firstname='test' WHERE Lastname='testing' "