Hi i got a slight sql problem i get a runtime error
http://htmlschool.co.uk/images/sql.JPGQuote:
Syntax error in UPDATE statement
any ideas??
thanks all
Printable View
Hi i got a slight sql problem i get a runtime error
http://htmlschool.co.uk/images/sql.JPGQuote:
Syntax error in UPDATE statement
any ideas??
thanks all
what is the datatype for the SCRNAME field?...to allow it to have the accent mark above the "n" in "Senorbedger" the datatype should be nvarchar.
Here would be my assumptions based on the field names.
1) Any field that ends with ID (UserID) would be an int datatype and not accept strings, it would accept only numbers. The field would be better suited as Username = 'sam', rather than UserID = 'sam'.
2) Level would be an int type also, therefore you wouldn't need (') marks around the number 2....(') marks are only for strings, not numbers.
3) Same for field name ID...shouldn't be '1', it should be 1