Member Avatar for swenzy

plz send a solution for this

"update login SET password=@password,username=@username where username=@user"

while executing i got the error"syntax error in update statement "

plz reply me how can i solve the error

Edited by kvprajapati because: Added [code] tags. For easy readability, always wrap programming code within posts in [code] (code blocks).
  • 3 Contributors
  • 2 Replies
  • 151 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for ammadiqbal

there is No error in this Syntax
I think you checked you variables

Member Avatar for kvprajapati

>while executing i got the error "syntax error in update statement"

Maybe problem using database Reserved words.

update [login] SET [password]=@password, [username]=@username where [username]=@user
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.