Skip to main content
Participant
March 14, 2007
Answered

Can't insert or update password column

  • March 14, 2007
  • 2 replies
  • 510 views
For the website I am building I am having problems with the add member, edit member, and change password pages. I have determined that the problem lies with inserting or updating the password column of the database. If i remove the password field from both the add and edit member pages, they work fine (doing so to the change password page would defeat it's purpose, so have not tried it there). I use dream weaver 8 to design it, and was wondering if there is something in the log in user and restrict access (user, password, and level) server behaviors it's tool creates that would some how lock that column out from being changed. Can anyone help me with this problem please?
This topic has been closed for replies.
Correct answer Newsgroup_User
it's probably a reserved word, try escaping the field name with brackets
(e.g. [password]), or rename it.
HTH
--
Tim Carley
www.recfusion.com
info@NOSPAMINGrecfusion.com

2 replies

Newsgroup_UserCorrect answer
Inspiring
March 14, 2007
it's probably a reserved word, try escaping the field name with brackets
(e.g. [password]), or rename it.
HTH
--
Tim Carley
www.recfusion.com
info@NOSPAMINGrecfusion.com
JasonCFAuthor
Participant
March 15, 2007
Thank you very much Tim! You had it just right , and even gave me an excellent example to help me understand what you meant. That took care of the problem and saved me a major headache. Thank you for your help.

Dan I appreciate your taking the time to look over my question. I'm sorry I didn't include the info you asked for originally, but I figured with what I explained what was happening and the circumstances around it, someone would know exactly what the problem was.

This is my 2nd website, but first using cold fusion, and I think I got myself in a little deep first time out, but I am getting the hang of it. Once again, thank you so much Tim for helping me fix my problem
Inspiring
March 14, 2007
What exactly happens when you try to add or update a record?
What is the datatype of the password field?
What does your update query look like?