Member Avatar for joel.blundell.5

I'm trying to do my Computing coursework, and every time I try to write an UPDATE statement in SQL, it tells me there is a syntax error in the statement. The connection is set up, I know, as other SQL statements like select statements work, but I can't work out what is wrong. Here's the code:

newpass = newpassword1.Text
passwordchange = "UPDATE Student SET Password = '" & newpass & "' WHERE Username = '" & username & "';"

All of table and field names are correct and in the right format etc. and newpass and username both read in string values.

Any ideas? :/

Edited by pritaeas because: Added code tags
  • 5 Contributors
  • 5 Replies
  • 194 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by ShahanDev
Member Avatar for deceptikon

Try removing the semicolon.

Member Avatar for G_Waddell

Hi,

Have you tried running in debug and doing watches on newpass and passwordchange?

Maybe newpassword1.text is empty?

Also how are you running the passwordchange query through a sql command? could you show us the code where yu execute the query?

Member Avatar for Reverend Jim

Password is a reserved word. Try

passwordchange = "UPDATE Student SET [Password] = '" & newpass & "' WHERE Username = '" & username & "';"
Member Avatar for Reverend Jim

And, of course, you should be using parameterized queries. See example here

Member Avatar for ShahanDev

Can you post the error message you received ? It will help us to figure out the problem.

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.