Im using Dreamweaver MX with a php/mysql page for internal use...ie no public face to it. I'm trying to make a change password page for the users, but everytime I try to add an Update Record action to the form, Dreamweaver says it wants a primary key value. OK, I understand that, it needs to know where to update, but it should get that from the recordset. I had the record set to pull session variables for username (userID is the PK, not username because ID is numeric and name is not) so my update should be able to pull from that right? So why won't it accept the value? I have to select that the "new password" field is going to be passed as text from the form, so the record set should determine where it is going to go. I've been playing around with scripts and different layouts for a couple days and just don't seem to be getting anywhere.
