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:

suffix mapping for NT? (1997) Show shoppingcart after remove last item (1997) Kaaaaahhhhhhhnnnnnnn! (1997) UPS Shipping Docs (Where To Go) (1999) Type 2 errors with WebCatalog.acgi (1997) Possible Bug 4.51 (2004) FM and Webcat together? (1998) raw field names (2001) problem: search crashes webstar (1997) [applescript] (1999) Summing fields (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) WebCat2: multiple currency support (1997) [isfile] ? (1997) $purchase WITHOUT creditcar (1997) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) WebCat editing, SiteGuard & SiteEdit (1997) setting the price of goods after its added to the cart (2000) problems with 2 tags (1997) Follow-Up to: Removing [showif] makes a big difference in speed (1997)