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 FriesBrainScan SoftwareOn 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:

Re: [WebDNA] Delete founditems ("Terry Wilson" 2010)
Re: [WebDNA] Delete founditems (Rich Kwas 2010)
Re: [WebDNA] Delete founditems ("Terry Wilson" 2010)
Re: [WebDNA] Delete founditems (Brian Fries 2010)
Re: [WebDNA] Delete founditems (Govinda 2010)
[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 FriesBrainScan SoftwareOn 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!

Re: [WebDNA] Delete founditems

2010

Top Articles:

Related Readings: