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:
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!
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:
Netscape (1997)
# fields limited? (1997)
For those of you not on the WebCatalog Beta... (1997)
Fwd: Problems with Webcatalog Plug-in (1997)
unable to launch acgi in WebCat (1997)
send mail problem? (1997)
all records returned. (1997)
Concerning Emailer under Linux... does it exist? (2000)
MacOS X upgrade pricing plan (1999)
Ampersand (1997)
proper way to check if a container is empty? (2000)
WebDNA4.5 OS-X CPU Usage? (2003)
RE: Automatic Forwarding using WebCat (1997)
Sorry, WebCatalog Server Not Running (2002)
What is WebDNA (1997)
indexing dates (1998)
Configuring E-mail (1997)
Multiple prices (1997)
[WebDNA] rules for naming [math] and [text] vars (2008)
WebCat2 - storing unformatted date data? (1997)