This content has been marked as final. Show 5 replies
Perhaps this is a reserved word problem, with the word password. I don't use access myself so I am not sure, but it's something that comes up on these forums a lot.
I would guess that the UserRoleID is an integer and should not have quotes around it.
BTW - you may want to post questions like this under the Getting Started Forum versus Advanced Techniques.
I had this exact same problem with a CFMX 7 datasource that was set up as Microsoft Access with Unicode. It turns out that "Password" is a reserved word in the Unicode driver. Or somewhere. I got around it by putting square brackets, i.e., [ ] around the column name, like this:
set [Password] = '#form.Password#'
where UserID = '#form.UserID#'
That solved the problem nicely. I hope this solution will work for you as well.
You may want to use <cfqueryparam ... /> just in case someone
has a password with escape characters.
Thank you all. It appears that the reserve word was indeed the problem. Used 'pword' instead. I will also ask these types of questions on the getting started board as suggested.