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:
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)