I'm trying to use the "Update Record" server behavior on Dreamweaver 8 but the
dialog asks me to identify a unique column. The table I'm trying to update
uses two columns together as the primary key. The dialog box won't let me
select two columns. Is there any way around this restriction?

Jupiter Man wrote:

> I'm trying to use the "Update Record" server behavior on Dreamweaver
> 8 but the dialog asks me to identify a unique column. The table I'm
> trying to update uses two columns together as the primary key. The
> dialog box won't let me select two columns. Is there any way around
> this restriction?


Manually change it after runing the behavior.

I don't know how to do this manually. Is it possible to be more specific?

Jupiter Man wrote:

> I don't know how to do this manually. Is it possible to be more
> specific?


This means you will need to know sql and change the code the behavior
creates. For instanes the where clause might now say

where tb11.firstkeyfld = tbl2.afield2

You really want

where tb11.firstkeyfld = tbl2.afield2 and tbl1.secondkeyfld =
tbl2.anotherfld

Thanks for sticking with me on this.

I couldn't find any "where clause" in my page's source code so I decided to do
a workaround and add a unique key column to the database table. This seems to
work fine.

Thanks again.