Re: Deleting Multiple Database Records based on Checkbox
This WebDNA talk-list message is from
1998
It keeps the original formatting.
numero = 18996
interpreted = N
texte = The way I do this is as follows:1) Each checkbox is assigned a name corresponding to its index. [SEARCH ....] [founditems] [/founditems] [/SEARCH] 2) Submit Form 3) On the processform page: a) Delete [db=mydatabase.db&neFIELD1data=0] Delete all Records in your database b) Rewrite all records in your database using the append context, but hide the append if the user asks to delete the record [LOOP start=1&end=[NumberOfItems]] [HIDEIF [Interpret][DeleteMe[INDEX]][/Interpret]=yes] [append].......[/append] [/HIDEIF] [/LOOP] >I am currently working on a To Do List for a local Elementary School >Staff. I would like for each teacher to be able to add and delete items >from their To Do List. Here's how I would like the delete feature to >work...for each Item listed a checkbox. They check the ones they want to >delete from the To Do List, then click a button and all of those items >are deleted from the database in one clean sweep. I've searched the >archives, and so far haven't found any past discussion on deleting multiple >database records based on a checkbox....can someone point me in the right >direction please?? > >Here's what I have so far: > > >www.cnetech.com/school/classroom/teachersdesk/ > >username=jsmith >password=jsmith > >Database fields: username, todoitem, priority, deadline > >Thanks in Advance, >Kimberly Wyrick >CNETech Net >_________________________ >Check out www.cnetech.com ! ----------------------------------------------------------------------- Steve Rosenbaum Pop Art L.L.C. http://pop-art.com steve@pop-art.com Networks / Databases / Multimedia7000 SW Hampton St., Suite 124, tel: (503) 968.5957 Tigard, OR 97223-8361 fax: (503) 620.8487
Associated Messages, from the most recent to the oldest:
The way I do this is as follows:1) Each checkbox is assigned a name corresponding to its index. [SEARCH ....] [founditems] [/founditems] [/SEARCH] 2) Submit Form 3) On the processform page: a) Delete [db=mydatabase.db&neFIELD1data=0] Delete all Records in your database b) Rewrite all records in your database using the append context, but hide the append if the user asks to delete the record [LOOP start=1&end=[NumberOfItems]] [HIDEIF [interpret][DeleteMe[INDEX]][/Interpret]=yes] [append].......[/append] [/HIDEIF] [/LOOP] >I am currently working on a To Do List for a local Elementary School >Staff. I would like for each teacher to be able to add and delete items >from their To Do List. Here's how I would like the delete feature to >work...for each Item listed a checkbox. They check the ones they want to >delete from the To Do List, then click a button and all of those items >are deleted from the database in one clean sweep. I've searched the >archives, and so far haven't found any past discussion on deleting multiple >database records based on a checkbox....can someone point me in the right >direction please?? > >Here's what I have so far: > > >www.cnetech.com/school/classroom/teachersdesk/ > >username=jsmith >password=jsmith > >Database fields: username, todoitem, priority, deadline > >Thanks in Advance, >Kimberly Wyrick >CNETech Net >_________________________ >Check out www.cnetech.com ! ----------------------------------------------------------------------- Steve Rosenbaum Pop Art L.L.C. http://pop-art.com steve@pop-art.com Networks / Databases / Multimedia7000 SW Hampton St., Suite 124, tel: (503) 968.5957 Tigard, OR 97223-8361 fax: (503) 620.8487
Steve Rosenbaum
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...