Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update statement

Status
Not open for further replies.
Ablecken

Ablecken

Programmer
Joined
Jun 5, 2001
Messages
130
Location
US
I need help with this.

Does anybody see anything wrong with this?

UPDATE userlogin SET password='asdf' WHERE user='Justin'

thanx
 
Sort by date Sort by votes
Try surrounding your password and user in []'s

They're reserved words in some DBMS's

UPDATE userlogin SET [password]='asdf' WHERE [user]='Justin'

:-)
paul
penny.gif
penny.gif
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question Question
How to update the content of radio buttons in a database?
Replies
2
Views
519
leifoet
leifoet
leifoet
  • Locked
  • Question Question
Classic ASP multiple record update with Access
Replies
7
Views
876
dhookom
dhookom
leifoet
  • Locked
  • Question Question
How to update current date and time in an databasefield
Replies
1
Views
417
leifoet
leifoet
axLW
  • Locked
  • Question Question
And Statement
Replies
2
Views
319
axLW
axLW
Tord Bergset
  • Locked
  • Question Question
Classic asp - Only some active directory attributes can be updated.
Replies
3
Views
628
Tord Bergset
Tord Bergset

Part and Inventory Search

Sponsor

Back
Top