Re: Deleting Multiple Database Records based on Checkbox
This WebDNA talk-list message is from
1998
It keeps the original formatting.
numero = 18995
interpreted = N
texte = At 10:51 Uhr 21.07.1998, Kimberly Wyrick wrote: >I've searched the >archives, and so far haven't found any past discussion on deleting multiple >database records based on a checkbox... > >Database fields: username, todoitem, priority, deadline Add a field with a unique ID to your database: todoID, username, todoitem, priority, deadline (you can use [cart] to generate the ID when you store a new record)In your form, name the checkboxes with some prefix and their ID's: deleteOn your response page: [formvariables] [showif [name]^cb_] [DELETE db=todo.db&eqIDdata=[getchars start=4][name][/getchars]] [/showif] [/formvariables] How it works: Checkboxes which are activated show up inside the [formvariables] loop, others not. With [showif] you ask if it is a checkbox you want to deal with (because of its prefix cb_) Inside the DELETE context the pure ID gets extracted and the record deleted. Peter__________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21
Associated Messages, from the most recent to the oldest:
At 10:51 Uhr 21.07.1998, Kimberly Wyrick wrote: >I've searched the >archives, and so far haven't found any past discussion on deleting multiple >database records based on a checkbox... > >Database fields: username, todoitem, priority, deadline Add a field with a unique ID to your database: todoID, username, todoitem, priority, deadline (you can use [cart] to generate the ID when you store a new record)In your form, name the checkboxes with some prefix and their ID's: deleteOn your response page: [formvariables] [showif [name]^cb_] [DELETE db=todo.db&eqIDdata=[getchars start=4][name][/getchars]] [/showif] [/formvariables] How it works: Checkboxes which are activated show up inside the [formvariables] loop, others not. With [showif] you ask if it is a checkbox you want to deal with (because of its prefix cb_) Inside the DELETE context the pure ID gets extracted and the record deleted. Peter__________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21
Peter Ostry
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...