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:

SSL do I need it?? (1998) WebMerchant - MacAuthorize (1999) Old Topic - [OT] - server speeds. (2002) Using the sendmail command on CGate Pro (Unix) (2000) Soft return (2001) Speed Admin? (Was FlushDatabases) (1997) For those of you not on the WebCatalog Beta... (1997) template not found error (1998) Emailer error 550? (1999) Hummm .... (1998) Format of Required fields error message (1997) Securing a Directory (2000) OT: Verbose messages - Web*4.2 (2000) emailer and bad addresses (1997) Some Questions (1997) Re:2nd WebCatalog2 Feature Request (1996) WebCat and image maps (1997) WebDNA Freelancer Needed (2002) WebCat2 - [format thousands] (1997) 3-4.1 probelm (2000)