In addition to what the others have said, on nearly all my deletes, I make an=A0=A0"Are you sure?" confirmati= on link, which in turn deletes for good. But=A0if it's a multi-record delete,=A0I often display the list of things to be deleted= as well, along with the confirmation.
-Terry
On Sat, 9 Jan 2010 07:31:03 -0800
Brian Fries <dna@brainscansoftware.com> wrote:
> Se= e 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 del= eted, 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 d= b=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=3D= 1/8/2010]
>
[founditems]> [showif [planets]=3D[aligned]]
>
[text]tDeleteMe=3D[tDeleteMe][myUniqueK= ey],[/text]
> [/showif]
> [/founditems]
> [/search]
> [delete
>db=3Dmy.db&w= omyUniqueKeydatarq=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 talk= list archives?
>>
>> I see one going to July 2008
>> Are the most recent ones somewhere els= e??
>>
>>
>>
>>
>> I was doing some searches but wasn't coming up = with
>>relative results for my task of the day:
>>
>> I have a bunch of form submissions w= ritten into a
>>database that are dealt with and a reply is sent back to
>>the submitter.
>= >
>> I want to delete a bunch of these original requests,
>>lets say all the ones from 1/8/2010 = as an example.
>>
>> there could be 5, 20 or 60, every day is different.
>>
>> Is= there a simple way to delete a group of founditems?
>>
>> Would that be the best way (if even = possible... that's
>>what I was searching the talklist for)
>>
>> ....or do I look int= o
[loop] and delete them one by one
>>etc.
>>
>>
>> Showing all the su= bmissions from a particular date is
>>easily done right now in this site...
>>
>>= ;
>>
>> I'm on Windows Server 2003, vers 6.0 of webdna.....
>>
>>
>>= ; Thanks
>>
>>
>>
>>
>>
>> ----------------------------------= -----------------------
>> This message is sent to you because you are subscribed
>>to
>&= gt; the mailing list <talk@webdna.us>.
>> To unsubscribe, E-mail to: <talk-l= eave@webdna.us>
>> 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=3Dtopi= cs&category=3D288
>
> ---------------------------------------------------------
> This me= ssage is sent to you because you are subscribed
>to
> the mailing list <talk@webdna.us>.
> To un= subscribe, E-mail to: <talk-leave@webdna.us>
> 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
=A0=