Re: [WebDNA] Delete founditems

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 104331
interpreted = N
texte = See the links at the bottom of this email for the Old and New list = archives. As for deleting found items, if you want to delete ALL the items found = by your search, it's easy. If only SOME should be deleted, it's more = difficult. To delete ALL, simply use the same parameters in your DELETE as you = would in your SEARCH: [delete db=3Dmy.db&eqmyDatedatarq=3D1/8/2010] To delete SOME, this DOES NOT WORK because the deletion of the records = messes with the found item set: [search db=3Dmy.db&eqmyDatedatarq=3D1/8/2010] [founditems] [showif planets=3D[aligned]] [delete = db=3Dmy.db&eqmyUniqueKeydatarq=3D[myUniqueKey]] [/showif] [/founditems] [/search] To resolve this, I generally save a list of unique keys to be deleted in = a text variable, then delete them in a batch after the [/search]: [text]tDeleteMe=3D[/text] [search db=3Dmy.db&eqmyDatedatarq=3D1/8/2010] [founditems] [showif [planets]=3D[aligned]] [text]tDeleteMe=3D[tDeleteMe][myUniqueKey],[/text]= [/showif] [/founditems] [/search] [delete db=3Dmy.db&womyUniqueKeydatarq=3D[tDeleteMe]&myUniqueKeyword=3Dww]= This assumes that your records have a simple unique key value (I always = include a unique "ID" number as a field in my databases). If you don't = then you need to expand on this concept a bit. Brian Fries BrainScan Software On Jan 9, 2010, at 5:46 AM, Rich Kwas wrote: > Before I ask.... > Are there 2 talklist archives? >=20 > I see one going to July 2008 > Are the most recent ones somewhere else?? >=20 >=20 >=20 >=20 > I was doing some searches but wasn't coming up with relative results = for my task of the day: >=20 > I have a bunch of form submissions written into a database that are = dealt with and a reply is sent back to the submitter. >=20 > I want to delete a bunch of these original requests, lets say all the = ones from 1/8/2010 as an example. >=20 > there could be 5, 20 or 60, every day is different. >=20 > Is there a simple way to delete a group of founditems? >=20 > Would that be the best way (if even possible... that's what I was = searching the talklist for) >=20 > ....or do I look into [loop] and delete them one by one etc. >=20 >=20 > Showing all the submissions from a particular date is easily done = right now in this site... >=20 >=20 >=20 > I'm on Windows Server 2003, vers 6.0 of webdna..... >=20 >=20 > Thanks >=20 >=20 >=20 >=20 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Delete founditems ("Terry Wilson" 2010)
  2. Re: [WebDNA] Delete founditems (Rich Kwas 2010)
  3. Re: [WebDNA] Delete founditems ("Terry Wilson" 2010)
  4. Re: [WebDNA] Delete founditems (Brian Fries 2010)
  5. Re: [WebDNA] Delete founditems (Govinda 2010)
  6. [WebDNA] Delete founditems (Rich Kwas 2010)
See the links at the bottom of this email for the Old and New list = archives. As for deleting found items, if you want to delete ALL the items found = by your search, it's easy. If only SOME should be deleted, it's more = difficult. To delete ALL, simply use the same parameters in your DELETE as you = would in your SEARCH: [delete db=3Dmy.db&eqmyDatedatarq=3D1/8/2010] To delete SOME, this DOES NOT WORK because the deletion of the records = messes with the found item set: [search db=3Dmy.db&eqmyDatedatarq=3D1/8/2010] [founditems] [showif planets=3D[aligned]] [delete = db=3Dmy.db&eqmyUniqueKeydatarq=3D[myUniqueKey]] [/showif] [/founditems] [/search] To resolve this, I generally save a list of unique keys to be deleted in = a text variable, then delete them in a batch after the [/search]: [text]tDeleteMe=3D[/text] [search db=3Dmy.db&eqmyDatedatarq=3D1/8/2010] [founditems] [showif [planets]=3D[aligned]] [text]tDeleteMe=3D[tDeleteMe][myUniqueKey],[/text]= [/showif] [/founditems] [/search] [delete db=3Dmy.db&womyUniqueKeydatarq=3D[tDeleteMe]&myUniqueKeyword=3Dww]= This assumes that your records have a simple unique key value (I always = include a unique "ID" number as a field in my databases). If you don't = then you need to expand on this concept a bit. Brian Fries BrainScan Software On Jan 9, 2010, at 5:46 AM, Rich Kwas wrote: > Before I ask.... > Are there 2 talklist archives? >=20 > I see one going to July 2008 > Are the most recent ones somewhere else?? >=20 >=20 >=20 >=20 > I was doing some searches but wasn't coming up with relative results = for my task of the day: >=20 > I have a bunch of form submissions written into a database that are = dealt with and a reply is sent back to the submitter. >=20 > I want to delete a bunch of these original requests, lets say all the = ones from 1/8/2010 as an example. >=20 > there could be 5, 20 or 60, every day is different. >=20 > Is there a simple way to delete a group of founditems? >=20 > Would that be the best way (if even possible... that's what I was = searching the talklist for) >=20 > ....or do I look into [loop] and delete them one by one etc. >=20 >=20 > Showing all the submissions from a particular date is easily done = right now in this site... >=20 >=20 >=20 > I'm on Windows Server 2003, vers 6.0 of webdna..... >=20 >=20 > Thanks >=20 >=20 >=20 >=20 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 Brian Fries

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

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...

Related Readings:

select multiple 2 more cents (1997) RAM variables (1997) shipcost (1997) Newbie problem blah blah blah (1997) more cookie crumbling (1999) webcat nt (1997) Upgrade to Tiger? (2006) GuestBook example (1997) Problems reading files created by WC (1997) one item in several different categories? (2000) WebCat2b15MacPlugin - showing [math] (1997) When to Commitdatabase? (2004) WC2.0 Memory Requirements (1997) PCSDecrypt bugs still unfixed ... (2000) Add a field to the error log? (1997) Odd Cart Behavior (1997) OT: Backup Strategies (2007) WCS Newbie question (1997) Summing fields (1997) ShowNext example for GeneralStore (1997)