Yes, delete can be very simple. The only thing is, once it's gone, it's gone, so just be careful.
On Sa= t, 9 Jan 2010 08:08:53 -0800 (PST)
Rich Kwas <richkwasniewski@yahoo.com> wrote:
>
> Something = along this route should work for what I'm
>gonna do.
> I'll try it next
>
>> [delete d= b=3Dmy.db&eqmyDatedatarq=3D1/8/2010]
>
> Thanks for the tips and the heads up on ALL the archives
>= Guess I never looked at the bottom of the list emails
>LOL
>
>
> --- On Sat, 1/9/10, Brian Fr= ies
><dna@brainscansoftware.com> wrote:
>
>> From: Brian Fries <dna@brainscansoftware.c= om>
>> Subject: Re: [WebDNA] Delete founditems
>> To: talk@webdna..us
>> Date: Saturday, Ja= nuary 9, 2010, 9:31 AM
>> See the links at the bottom of this
>> email for the Old and New list ar= chives.
>>
>> As for deleting found items, if you want to delete ALL
>>the
>&g= t; 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 del= ete 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]
>> =A0=A0=A0 [foundite= ms]
>> =A0=A0=A0 =A0=A0=A0 [showif
>> planets=3D[aligned]]
>> =A0=A0=A0 =A0=A0=A0 =A0=A0=A0
>>= ; [delete db=3Dmy.db&eqmyUniqueKeydatarq=3D[myUniqueKey]]
>> =A0=A0=A0 =A0=A0=A0 [/showif]
>> =A0=A0=A0 [/founditems]
>= > [/search]
>>
>> To resolve this, I generally save a list of unique keys
>>to
>> be delete= d in a text variable, then delete them in a
>>batch
>> after the [/search]:
>>
>&g= t; [text]tDeleteMe=3D[/text]
>> [search db=3Dmy.db&eqmyDatedatarq=3D1/8/2010]
>> =A0=A0=A0 [foundite= ms]
>> =A0=A0=A0 =A0=A0=A0 [showif
>> [planets]=3D[aligned]]
>> =A0=A0=A0 =A0=A0=A0 =A0=A0=A0
>&= gt; [text]tDeleteMe=3D[tDeleteMe][myUniqueKey],[/text]
>> =A0=A0= =A0 =A0=A0=A0 [/showif]
>> =A0=A0=A0 [/founditems]
>> [/search]
&g= t;> [delete
>> db=3Dmy.db&womyUniqueKeydatarq=3D[tDeleteMe]&myUniqueKeyword=3Dww= ]
>>
>> This assumes that your records have a simple unique key
>> value (I always include a un= ique "ID" number as a field
>>in
>> my databases). If you don't then you need to e= xpand on
>>this
>> concept a bit.
>>
>>
>> Brian Fries
>> BrainS= can Software
>>
>>
>> On Jan 9, 2010, at 5:46 AM, Rich Kwas wrote:
>> >> > Before I ask....
>> > Are there 2 talklist archives?
>> >
>> > I = see one going to July 2008
>> > Are the most recent ones somewhere else??
>> >
>> > =
>> >
>> >
>> > 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 submission= s written into a
>> database that are dealt with and a reply is sent back to
>>the
>> submit= ter.
>> >
>> > I want to delete a bunch of these original requests,
>> lets say all th= e 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 into [loop] and delete them one by
>> one etc.
>= > >
>> >
>> > Showing all the submissions from a particular date is
>> easily = done right now in this site...
>> >
>> >
>> >
>> > I'm on Windows Serv= er 2003, vers 6.0 of webdna......
>> >
>> >
>> > Thanks
>> >
>= > >
>> >
>> >
>> >
>> >
>> -------------------------= --------------------------------
>> > This message is sent to you because you are subscribed
>> t= o
>> > the mailing list <talk@webdna.us>.
>> > To unsubscribe, E-mail to: <t= alk-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=3D= topics&category=3D288
>>
>> --------------------------------------------------------->> This message is sent to you because you are subscribed
>>to
>> the mailing list <talk@w= ebdna.us>.
>> To unsubscribe, 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&catego= ry=3D288
>>
>
>
>
>
> -----------------------= ----------------------------------
> This message is sent to you because you are subscribed
>to
> the = mailing list <talk@webdna.us>.
> To unsubscribe, E-mail to: <talk-leave@webdna.us>
> archives: ht= tp://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=3D= 288
=A0
Yes, delete can be very simple. The only thing is, once it's gone, it's gone, so just be careful.
On Sa= t, 9 Jan 2010 08:08:53 -0800 (PST)
Rich Kwas <richkwasniewski@yahoo.com> wrote:
>
> Something = along this route should work for what I'm
>gonna do.
> I'll try it next
>
>> [delete d= b=3Dmy.db&eqmyDatedatarq=3D1/8/2010]
>
> Thanks for the tips and the heads up on ALL the archives
>= Guess I never looked at the bottom of the list emails
>LOL
>
>
> --- On Sat, 1/9/10, Brian Fr= ies
><dna@brainscansoftware.com> wrote:
>
>> From: Brian Fries <dna@brainscansoftware.c= om>
>> Subject: Re: [WebDNA] Delete founditems
>> To: talk@webdna..us
>> Date: Saturday, Ja= nuary 9, 2010, 9:31 AM
>> See the links at the bottom of this
>> email for the Old and New list ar= chives.
>>
>> As for deleting found items, if you want to delete ALL
>>the
>&g= t; 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 del= ete 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]
>> =A0=A0=A0 [foundite= ms]
>> =A0=A0=A0 =A0=A0=A0 [showif
>> planets=3D[aligned]]
>> =A0=A0=A0 =A0=A0=A0 =A0=A0=A0
>>= ; [delete db=3Dmy.db&eqmyUniqueKeydatarq=3D[myUniqueKey]]
>> =A0=A0=A0 =A0=A0=A0 [/showif]
>> =A0=A0=A0 [/founditems]
>= > [/search]
>>
>> To resolve this, I generally save a list of unique keys
>>to
>> be delete= d in a text variable, then delete them in a
>>batch
>> after the [/search]:
>>
>&g= t; [text]tDeleteMe=3D[/text]
>> [search db=3Dmy.db&eqmyDatedatarq=3D1/8/2010]
>> =A0=A0=A0 [foundite= ms]
>> =A0=A0=A0 =A0=A0=A0 [showif
>> [planets]=3D[aligned]]
>> =A0=A0=A0 =A0=A0=A0 =A0=A0=A0
>&= gt; [text]tDeleteMe=3D[tDeleteMe][myUniqueKey],[/text]
>> =A0=A0= =A0 =A0=A0=A0 [/showif]
>> =A0=A0=A0 [/founditems]
>> [/search]
&g= t;> [delete
>> db=3Dmy.db&womyUniqueKeydatarq=3D[tDeleteMe]&myUniqueKeyword=3Dww= ]
>>
>> This assumes that your records have a simple unique key
>> value (I always include a un= ique "ID" number as a field
>>in
>> my databases). If you don't then you need to e= xpand on
>>this
>> concept a bit.
>>
>>
>> Brian Fries
>> BrainS= can Software
>>
>>
>> On Jan 9, 2010, at 5:46 AM, Rich Kwas wrote:
>> >> > Before I ask....
>> > Are there 2 talklist archives?
>> >
>> > I = see one going to July 2008
>> > Are the most recent ones somewhere else??
>> >
>> > =
>> >
>> >
>> > 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 submission= s written into a
>> database that are dealt with and a reply is sent back to
>>the
>> submit= ter.
>> >
>> > I want to delete a bunch of these original requests,
>> lets say all th= e 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 into [loop] and delete them one by
>> one etc.
>= > >
>> >
>> > Showing all the submissions from a particular date is
>> easily = done right now in this site...
>> >
>> >
>> >
>> > I'm on Windows Serv= er 2003, vers 6.0 of webdna......
>> >
>> >
>> > Thanks
>> >
>= > >
>> >
>> >
>> >
>> >
>> -------------------------= --------------------------------
>> > This message is sent to you because you are subscribed
>> t= o
>> > the mailing list <talk@webdna.us>.
>> > To unsubscribe, E-mail to: <t= alk-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=3D= topics&category=3D288
>>
>> --------------------------------------------------------->> This message is sent to you because you are subscribed
>>to
>> the mailing list <talk@w= ebdna.us>.
>> To unsubscribe, 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&catego= ry=3D288
>>
>
>
>
>
> -----------------------= ----------------------------------
> This message is sent to you because you are subscribed
>to
> the = mailing list <talk@webdna.us>.
> To unsubscribe, E-mail to: <talk-leave@webdna.us>
> archives: ht= tp://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=3D= 288
=A0The 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...