What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Re: [WebDNA] Delete founditems

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 104333
interpreted = N
texte = =0ASomething along this route should work for what I'm gonna do.=0AI'll try= it next=0A=0A> [delete db=3Dmy.db&eqmyDatedatarq=3D1/8/2010]=0A=0AThanks f= or the tips and the heads up on ALL the archives=0AGuess I never looked at = the bottom of the list emails LOL=0A=0A=0A--- On Sat, 1/9/10, Brian Fries <= dna@brainscansoftware.com> wrote:=0A=0A> From: Brian Fries =0A> Subject: Re: [WebDNA] Delete founditems=0A> To: talk@webdna= ..us=0A> Date: Saturday, January 9, 2010, 9:31 AM=0A> See the links at the b= ottom of this=0A> email for the Old and New list archives.=0A> =0A> As for = deleting found items, if you want to delete ALL the=0A> items found by your= search, it's easy. If only SOME should=0A> be deleted, it's more difficult= ..=0A> =0A> To delete ALL, simply use the same parameters in your=0A> DELETE= as you would in your SEARCH:=0A> =0A> [delete db=3Dmy.db&eqmyDatedatarq=3D= 1/8/2010]=0A> =0A> To delete SOME, this DOES NOT WORK because the deletion = of=0A> the records messes with the found item set:=0A> [search db=3Dmy.db&e= qmyDatedatarq=3D1/8/2010]=0A> =A0=A0=A0 [founditems]=0A> =A0=A0=A0 =A0=A0= =A0 [showif=0A> planets=3D[aligned]]=0A> =A0=A0=A0 =A0=A0=A0 =A0=A0=A0=0A> = [delete db=3Dmy.db&eqmyUniqueKeydatarq=3D[myUniqueKey]]=0A> =A0=A0=A0 =A0= =A0=A0 [/showif]=0A> =A0=A0=A0 [/founditems]=0A> [/search]=0A> =0A> To reso= lve this, I generally save a list of unique keys to=0A> be deleted in a tex= t variable, then delete them in a batch=0A> after the [/search]:=0A> =0A> [= text]tDeleteMe=3D[/text]=0A> [search db=3Dmy.db&eqmyDatedatarq=3D1/8/2010]= =0A> =A0=A0=A0 [founditems]=0A> =A0=A0=A0 =A0=A0=A0 [showif=0A> [planets]= =3D[aligned]]=0A> =A0=A0=A0 =A0=A0=A0 =A0=A0=A0=0A> [text]tDeleteMe=3D[tDel= eteMe][myUniqueKey],[/text]=0A> =A0=A0=A0 =A0=A0=A0 [/showif]=0A> =A0=A0=A0= [/founditems]=0A> [/search]=0A> [delete=0A> db=3Dmy.db&womyUniqueKeydatarq= =3D[tDeleteMe]&myUniqueKeyword=3Dww]=0A> =0A> This assumes that your record= s have a simple unique key=0A> value (I always include a unique "ID" number= as a field in=0A> my databases). If you don't then you need to expand on t= his=0A> concept a bit.=0A> =0A> =0A> Brian Fries=0A> BrainScan Software=0A>= =0A> =0A> On Jan 9, 2010, at 5:46 AM, Rich Kwas wrote:=0A> =0A> > Before I= ask....=0A> > Are there 2 talklist archives?=0A> > =0A> > I see one going = to July 2008=0A> > Are the most recent ones somewhere else??=0A> > =0A> > = =0A> > =0A> > =0A> > I was doing some searches but wasn't coming up with=0A= > relative results for my task of the day:=0A> > =0A> > I have a bunch of f= orm submissions written into a=0A> database that are dealt with and a reply= is sent back to the=0A> submitter.=0A> > =0A> > I want to delete a bunch o= f these original requests,=0A> lets say all the ones from 1/8/2010 as an ex= ample.=0A> > =0A> > there could be 5, 20 or 60, every day is different.=0A>= > =0A> > Is there a simple way to delete a group of=0A> founditems?=0A> > = =0A> > Would that be the best way (if even possible... that's=0A> what I wa= s searching the talklist for)=0A> > =0A> > ....or do I look into [loop] and= delete them one by=0A> one etc.=0A> > =0A> > =0A> > Showing all the submis= sions from a particular date is=0A> easily done right now in this site...= =0A> > =0A> > =0A> > =0A> > I'm on Windows Server 2003, vers 6.0 of webdna.= .....=0A> > =0A> > =0A> > Thanks=0A> > =0A> > =0A> > =0A> > =0A> > =0A> >=0A= > ---------------------------------------------------------=0A> > This mess= age is sent to you because you are subscribed=0A> to=0A> > the mailing list= .=0A> > To unsubscribe, E-mail to: = =0A> > archives: http://mail.webdna.us/list/talk@webdna.us=0A> > old archiv= es: http://dev.webdna.us/TalkListArchive/=0A> > Bug Reporting: http://forum= ..webdna.us/eucabb.html?page=3Dtopics&category=3D288=0A> =0A> --------------= -------------------------------------------=0A> This message is sent to you= because you are subscribed to=0A> the mailing list .=0A> T= o unsubscribe, E-mail to: =0A> archives: http://mail.= webdna.us/list/talk@webdna.us=0A> old archives: http://dev.webdna.us/TalkLi= stArchive/=0A> Bug Reporting: http://forum.webdna.us/eucabb.html?page=3Dtop= ics&category=3D288=0A> =0A=0A=0A 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)
=0ASomething along this route should work for what I'm gonna do.=0AI'll try= it next=0A=0A> [delete db=3Dmy.db&eqmyDatedatarq=3D1/8/2010]=0A=0AThanks f= or the tips and the heads up on ALL the archives=0AGuess I never looked at = the bottom of the list emails LOL=0A=0A=0A--- On Sat, 1/9/10, Brian Fries <= dna@brainscansoftware.com> wrote:=0A=0A> From: Brian Fries =0A> Subject: Re: [WebDNA] Delete founditems=0A> To: talk@webdna= ..us=0A> Date: Saturday, January 9, 2010, 9:31 AM=0A> See the links at the b= ottom of this=0A> email for the Old and New list archives.=0A> =0A> As for = deleting found items, if you want to delete ALL the=0A> items found by your= search, it's easy. If only SOME should=0A> be deleted, it's more difficult= ..=0A> =0A> To delete ALL, simply use the same parameters in your=0A> DELETE= as you would in your SEARCH:=0A> =0A> [delete db=3Dmy.db&eqmyDatedatarq=3D= 1/8/2010]=0A> =0A> To delete SOME, this DOES NOT WORK because the deletion = of=0A> the records messes with the found item set:=0A> [search db=3Dmy.db&e= qmyDatedatarq=3D1/8/2010]=0A> =A0=A0=A0 [founditems]=0A> =A0=A0=A0 =A0=A0= =A0 [showif=0A> planets=3D[aligned]]=0A> =A0=A0=A0 =A0=A0=A0 =A0=A0=A0=0A> = [delete db=3Dmy.db&eqmyUniqueKeydatarq=3D[myUniqueKey]]=0A> =A0=A0=A0 =A0= =A0=A0 [/showif]=0A> =A0=A0=A0 [/founditems]=0A> [/search]=0A> =0A> To reso= lve this, I generally save a list of unique keys to=0A> be deleted in a tex= t variable, then delete them in a batch=0A> after the [/search]:=0A> =0A> [= text]tDeleteMe=3D[/text]=0A> [search db=3Dmy.db&eqmyDatedatarq=3D1/8/2010]= =0A> =A0=A0=A0 [founditems]=0A> =A0=A0=A0 =A0=A0=A0 [showif=0A> [planets]= =3D[aligned]]=0A> =A0=A0=A0 =A0=A0=A0 =A0=A0=A0=0A> [text]tDeleteMe=3D[tDel= eteMe][myUniqueKey],[/text]=0A> =A0=A0=A0 =A0=A0=A0 [/showif]=0A> =A0=A0=A0= [/founditems]=0A> [/search]=0A> [delete=0A> db=3Dmy.db&womyUniqueKeydatarq= =3D[tDeleteMe]&myUniqueKeyword=3Dww]=0A> =0A> This assumes that your record= s have a simple unique key=0A> value (I always include a unique "ID" number= as a field in=0A> my databases). If you don't then you need to expand on t= his=0A> concept a bit.=0A> =0A> =0A> Brian Fries=0A> BrainScan Software=0A>= =0A> =0A> On Jan 9, 2010, at 5:46 AM, Rich Kwas wrote:=0A> =0A> > Before I= ask....=0A> > Are there 2 talklist archives?=0A> > =0A> > I see one going = to July 2008=0A> > Are the most recent ones somewhere else??=0A> > =0A> > = =0A> > =0A> > =0A> > I was doing some searches but wasn't coming up with=0A= > relative results for my task of the day:=0A> > =0A> > I have a bunch of f= orm submissions written into a=0A> database that are dealt with and a reply= is sent back to the=0A> submitter.=0A> > =0A> > I want to delete a bunch o= f these original requests,=0A> lets say all the ones from 1/8/2010 as an ex= ample.=0A> > =0A> > there could be 5, 20 or 60, every day is different.=0A>= > =0A> > Is there a simple way to delete a group of=0A> founditems?=0A> > = =0A> > Would that be the best way (if even possible... that's=0A> what I wa= s searching the talklist for)=0A> > =0A> > ....or do I look into [loop] and= delete them one by=0A> one etc.=0A> > =0A> > =0A> > Showing all the submis= sions from a particular date is=0A> easily done right now in this site...= =0A> > =0A> > =0A> > =0A> > I'm on Windows Server 2003, vers 6.0 of webdna.= .....=0A> > =0A> > =0A> > Thanks=0A> > =0A> > =0A> > =0A> > =0A> > =0A> >=0A= > ---------------------------------------------------------=0A> > This mess= age is sent to you because you are subscribed=0A> to=0A> > the mailing list= .=0A> > To unsubscribe, E-mail to: = =0A> > archives: http://mail.webdna.us/list/talk@webdna.us=0A> > old archiv= es: http://dev.webdna.us/TalkListArchive/=0A> > Bug Reporting: http://forum= ..webdna.us/eucabb.html?page=3Dtopics&category=3D288=0A> =0A> --------------= -------------------------------------------=0A> This message is sent to you= because you are subscribed to=0A> the mailing list .=0A> T= o unsubscribe, E-mail to: =0A> archives: http://mail.= webdna.us/list/talk@webdna.us=0A> old archives: http://dev.webdna.us/TalkLi= stArchive/=0A> Bug Reporting: http://forum.webdna.us/eucabb.html?page=3Dtop= ics&category=3D288=0A> =0A=0A=0A Rich Kwas

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:

Lifestylus (was 4.5 Upgrade) (2003) PIXO (1997) Fun with dates (1997) Authenticate (1997) Separate SSL Server (1997) Re:Version 2.0 and 1.6 simultaneous (1997) Upgrade to wsV (2004) dreamweaver (2000) [sendmail] sending twice... (Update) (2003) First postarg not taking in $Commands (1997) referrer and no caches (1997) Converting a Magazine to a Web Site with WebCat (1999) WebCat2b12 - nesting [tags] (1997) Unable to view next 101-200 (1997) Running _every_ page through WebCat ? (1997) WebCatalog Mac 2.1b3 (1997) RE: PIXO support (1997) WebDNA 4.5 OSX/OS9 in exchange of WebDNA 4.5 Win (2004) ShowIf helper? (1998) Just Testing (1997)