Re: Deleting Multiple Database Records based on Checkbox
This WebDNA talk-list message is from
1998
It keeps the original formatting.
numero = 19016
interpreted = N
texte = It works!! Thanks a ton everyone =) At 11:22 PM 7/21/98, you wrote: >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: >delete > >On 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 > _________________________ Check out www.cnetech.com !
Associated Messages, from the most recent to the oldest:
It works!! Thanks a ton everyone =) At 11:22 PM 7/21/98, you wrote: >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: >delete > >On 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 > _________________________ Check out www.cnetech.com !
Kimberly Wyrick
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...