How can I delete records from database with multiple keyfields

[rtmarkley]

Say we have a simple set of tables: Authors, Books, and AuthorBooks; Authors
has an author_id primary key field; Books has a book_id primary key field; and
AuthorBooks has two key fields: author_id and book_id. Now say I want to
delete one of the AuthorBooks relationships on a web page with Dreamweaver. I
have a page with URL Form variables passed to it for author_id and book_id and
the record is displayed. I now add a delete button and I want to delete the
AuthorBooks record for the given record when the button is pressed. Under
server behaviors, I attempt to add the Delete Record behavior and the Delete
record dialog pops up. The Unique Key Column pull down only lets me select one
key field but I have two (author_id and book_id). How do I delete the record?
I am using the JSP Application model.

Thanks for any help!

Todd

[Paul Whitham TMM]

Your authorbook table needs to have a primary key of its own and then you
would use that to define the delete relationship.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"rtmarkley" <webforumsuser@macromedia.com> wrote in message
news:d0l4ph$gv4$1@forums.macromedia.com...

> Say we have a simple set of tables: Authors, Books, and AuthorBooks;

Authors

> has an author_id primary key field; Books has a book_id primary key

field; and

> AuthorBooks has two key fields: author_id and book_id. Now say I want to
> delete one of the AuthorBooks relationships on a web page with

Dreamweaver. I

> have a page with URL Form variables passed to it for author_id and book_id

and

> the record is displayed. I now add a delete button and I want to delete

the

> AuthorBooks record for the given record when the button is pressed. Under
> server behaviors, I attempt to add the Delete Record behavior and the

Delete

> record dialog pops up. The Unique Key Column pull down only lets me

select one

> key field but I have two (author_id and book_id). How do I delete the

record?

> I am using the JSP Application model.
>
> Thanks for any help!
>
> Todd
>

[CMBergin]

You'd need to write your own command rather than use the built-in one.

"rtmarkley" <webforumsuser@macromedia.com> wrote in message
news:d0l4ph$gv4$1@forums.macromedia.com...

> Say we have a simple set of tables: Authors, Books, and AuthorBooks;

Authors

> has an author_id primary key field; Books has a book_id primary key

field; and

> AuthorBooks has two key fields: author_id and book_id. Now say I want to
> delete one of the AuthorBooks relationships on a web page with

Dreamweaver. I

> have a page with URL Form variables passed to it for author_id and book_id

and

> the record is displayed. I now add a delete button and I want to delete

the

> AuthorBooks record for the given record when the button is pressed. Under
> server behaviors, I attempt to add the Delete Record behavior and the

Delete

> record dialog pops up. The Unique Key Column pull down only lets me

select one

> key field but I have two (author_id and book_id). How do I delete the

record?

> I am using the JSP Application model.
>
> Thanks for any help!
>
> Todd
>