Please submit at least one column as a primary key

Report · Apr 17, 2006

.php/MySql Dreamweaver 8 Professional

I have an 'edit' page that pulls in data from a MySQL table and populates text fields on a form to be able to edit records.
I pull in all the data of this table. The ID is the records primary key and just shown as dynamic text.

When I try creating a Server Behavior for 'Update Record', the Dialog Box opens, I select the connection, select the Table to be updated from the db, and all the columns show up fine and are matched well. 'ID' is even listed as "ID is an Unused Primary Key"... so I know it's being pulled and referenced within the record.

Everything looks good, and I press the 'OK' key and get the following message:

"Please submit at least one column as a primary key."

I don't want to offer a user the chance to change the ID (primary key), and the ID is pulled from the recordset, and used on the page just as dynamic text.

What am I missing? Not doing right?

Report · Apr 17, 2006

"caseykp" <webforumsuser@macromedia.com> wrote in message
news:e20jrm$c11$1@forums.macromedia.com...
> I don't want to offer a user the chance to change the ID (primary key),
> and
> the ID is pulled from the recordset, and used on the page just as dynamic
> text.
>
> What am I missing? Not doing right?
>

Assign the primary key to a hidden form field rather than plain dynamic
text.