Skip to main content
Inspiring
June 8, 2006
Question

Delete multiple records using check box?

  • June 8, 2006
  • 5 replies
  • 1036 views
Trying to delete multiple items in a repeat region using checkbox.

Anyone have some good links to tutorials that show how to do this.?


This topic has been closed for replies.

5 replies

Inspiring
June 9, 2006

"lee" <lfairban_nospam@amep.com> wrote in message
news:e6butt$9s6$1@forums.macromedia.com...

> How did I get so behind? That's rhetorical. Are most people out there
> using "command" instead of the pluggins built in Dreamweaver to update
> delete...?

Dreamweaver's built in behaviors also use command objects; there's just so
much surrounding code you might have missed it. DW's behaviors are severely
limited - a single insert, update, or delete on a single table. So I'd
wager that a majority of developers quickly learn to use command objects.
You'll find that DW will help you in that regard, too. One of your server
behaviors is Command (Stored Procedure), in which you can do an insert,
update, delete, select, or execute a stored procedure of your choosing.


Inspiring
June 9, 2006
Thanks for that link lionstone, there's some good material there.
"Lionstone" <HIDElionstone@HIDEhushmail.com> wrote in message
news:e6a5gi$2de$1@forums.macromedia.com...
> http://www.drdev.net/article02.asp
>
> "lee" <lfairban_nospam@amep.com> wrote in message
> news:e6a2v9$slu$1@forums.macromedia.com...
>> Trying to delete multiple items in a repeat region using checkbox.
>>
>> Anyone have some good links to tutorials that show how to do this.?
>>
>
>


Inspiring
June 9, 2006
I've noticed a paradygm shift here...Not sure when it took place but there
seems to be a greater dependence on "Command"

How did I get so behind? That's rhetorical. Are most people out there using
"command" instead of the pluggins built in Dreamweaver to update delete...?



Inspiring
June 8, 2006
http://www.drdev.net/article02.asp

"lee" <lfairban_nospam@amep.com> wrote in message
news:e6a2v9$slu$1@forums.macromedia.com...
> Trying to delete multiple items in a repeat region using checkbox.
>
> Anyone have some good links to tutorials that show how to do this.?
>


Inspiring
June 8, 2006
Create the form as normal and apply the delete behaiour to it. Make sure
that the value being passed to the checkbox is the ID of the record you want
to delete.

Then edit the SQL of the delete so that rather than saying
Where = variablename

it says

Where in (variablename)

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"lee" <lfairban_nospam@amep.com> wrote in message
news:e6a2v9$slu$1@forums.macromedia.com...
> Trying to delete multiple items in a repeat region using checkbox.
>
> Anyone have some good links to tutorials that show how to do this.?
>