Re: WARNING: deletedb anomaly

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 40442
interpreted = N
texte = I have noted that before as well - the max parameter is meaningless in a [delete] or [replace] context, as is the startat parameter.I understand the behavior, and I believe it is reasonable - the delete and replace operate on all the found items. [search] actually finds all the items, regardless of the max parameter (see [numfound]) -- the max and startat parameters really apply only to the [founditems] loop within the search.However, the documentation should be updated to clearly state this behavior.- brianAt 3:06 PM 6/4/02, Joseph D'Andrea wrote: >Docs say: > >...and delete those records. Any valid search parameters are >allowed, as defined in the Search command and [Search] context. > >When you put this in your template you get 300 records back. > >[search >db=addresslist.db&neTHEADDRESSdata=find_all&asMAILFLAGsort=1&MAILFLAGt >ype=num&max=300] > >However... > >When you put this in your template you get all records deleted. > >[delete >db=addresslist.db&neTHEADDRESSdata=find_all&asMAILFLAGsort=1&MAILFLAGt >ype=num&max=300] > > >Bummer... > >--joe >____________________________________________________________ >Joseph D'Andrea ~ http://www.west21.com/ ~ JoeDan@West21.com > WEST21.com Internet services for the 21st Century > webhosting ~ co-location ~ wireless access > WebCat and MGI database programming >____________________________________________________________-- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com => <= Macintosh, Internet and Multimedia http://www.artsofauburn.com => <= Development and Consulting =>------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: WARNING: deletedb anomaly (Joseph D'Andrea 2002)
  2. Re: WARNING: deletedb anomaly (Donovan 2002)
  3. Re: WARNING: deletedb anomaly (Brian Fries 2002)
  4. Re: WARNING: deletedb anomaly (John Peacock 2002)
  5. WARNING: deletedb anomaly (Joseph D'Andrea 2002)
I have noted that before as well - the max parameter is meaningless in a [delete] or [replace] context, as is the startat parameter.I understand the behavior, and I believe it is reasonable - the delete and replace operate on all the found items. [search] actually finds all the items, regardless of the max parameter (see [numfound]) -- the max and startat parameters really apply only to the [founditems] loop within the search.However, the documentation should be updated to clearly state this behavior.- brianAt 3:06 PM 6/4/02, Joseph D'Andrea wrote: >Docs say: > >...and delete those records. Any valid search parameters are >allowed, as defined in the Search command and [search] context. > >When you put this in your template you get 300 records back. > >[search >db=addresslist.db&neTHEADDRESSdata=find_all&asMAILFLAGsort=1&MAILFLAGt >ype=num&max=300] > >However... > >When you put this in your template you get all records deleted. > >[delete >db=addresslist.db&neTHEADDRESSdata=find_all&asMAILFLAGsort=1&MAILFLAGt >ype=num&max=300] > > >Bummer... > >--joe >____________________________________________________________ >Joseph D'Andrea ~ http://www.west21.com/ ~ JoeDan@West21.com > WEST21.com Internet services for the 21st Century > webhosting ~ co-location ~ wireless access > WebCat and MGI database programming >____________________________________________________________-- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com => <= Macintosh, Internet and Multimedia http://www.artsofauburn.com => <= Development and Consulting =>------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ 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:

Searchable list archive (1997) Looking up two prices in database? (1997) Running 2 two WebCatalog.acgi's (1996) PCS Frames (1997) Privacy Issue (LEGIT QUESTION) (2003) return two fields w/ [lookup] (1998) TARGET=window_name (1996) 5.0 feature request: (2001) [WebDNA] News: Apple leaves MacWorld (2008) WebCat2b15MacPlugin - showing [math] (1997) Trouble Searching (1999) [include] and v.email (1998) Emails sent twice (2000) Where's Cart Created ? (1997) Updating Integer value in DB (2007) This is an odd error (2001) Bug Report, maybe (1997) New Plug-in and Type 11 errors (1997) Help name our technology! (1997) FlushDatabase Suggestion (1998)