>1. Syntax error in UPDATE statement

hi, i think that the syntax error could ocurr with the name of field "password" or the type  because i read the senteces update and
o dont find any error.

hi ;)



>SQL statement without updating password that works fine:
>UPDATE Users SET firstname = 'Jenny', lastname = 'Munro', email 
>= 'pkysela@s...', address1 = '27 Mapperley road', address2 
>= 'Mapperley', city = 'London', postcode = 'NG5 6DE', country = 'UK' WHERE 
>userID = 14
>
>
>The same SQL statement attemting to update password:
>UPDATE Users SET firstname = 'Jenny', lastname = 'Munro', email 
>= 'pkysela@s...', password = 'rich', address1 = '27 Mapperley road', 
>address2 = 'Mapperley', city = 'London', postcode = 'NG5 6DE', country 
>= 'UK' WHERE userID = 14
>
>
>Error message:
>Microsoft JET Database Engine (0x80040E14)
>Syntax error in UPDATE statement.
>
>



___________________________________________________
GO.com Mail                                    
Get Your Free, Private E-mail at http://mail.go.com