Re: [BULK] Re: [WebDNA] [BULK] WebDNA 7 - Showing every other far DB - Fault!
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107294
interpreted = N
texte = --Boundary-01=_GzrWOricrV/Ky2kContent-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: 7bit> If you have a very sophisticated algorithm for deciding> which records need to be deleted (one that cannot be> expressed as normal search criteria), then I suggest you> first 'mark' the records you want to delete -- create a> new field called 'deleteMe', and default it to 0 (or> false), then any time you want to delete a record, set> that field to 1 (or true). Then, once you have marked> all the records you want to delete, execute a single> [Delete] with search criteria deleteMe=1Hmmm, that's precisely what my posted solution does!It marks the records to be deleted by setting the daily_index field to "remove" (no additional "deleteMe" field needed) then it deletes them all at once outside the founditems context.:)Sincerely,Kenneth Grome--Boundary-01=_GzrWOricrV/Ky2kContent-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: 7bit
> If you have a very sophisticated algorithm for deciding
> which records need to be deleted (one that cannot be
> expressed as normal search criteria), then I suggest you
> first 'mark' the records you want to delete -- create a
> new field called 'deleteMe', and default it to 0 (or
> false), then any time you want to delete a record, set
> that field to 1 (or true). Then, once you have marked
> all the records you want to delete, execute a single
> [Delete] with search criteria deleteMe=1
Hmmm, that's precisely what my posted solution does!
It marks the records to be deleted by setting the daily_index field to "remove" (no additional "deleteMe" field needed) then it deletes them all at once outside the founditems context.
:)
Sincerely,
Kenneth Grome
--Boundary-01=_GzrWOricrV/Ky2k--
Associated Messages, from the most recent to the oldest:
--Boundary-01=_GzrWOricrV/Ky2kContent-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: 7bit> If you have a very sophisticated algorithm for deciding> which records need to be deleted (one that cannot be> expressed as normal search criteria), then I suggest you> first 'mark' the records you want to delete -- create a> new field called 'deleteMe', and default it to 0 (or> false), then any time you want to delete a record, set> that field to 1 (or true). Then, once you have marked> all the records you want to delete, execute a single>
[delete] with search criteria deleteMe=1Hmmm, that's precisely what my posted solution does!It marks the records to be deleted by setting the daily_index field to "remove" (no additional "deleteMe" field needed) then it deletes them all at once outside the founditems context.:)Sincerely,Kenneth Grome--Boundary-01=_GzrWOricrV/Ky2kContent-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: 7bit
> If you have a very sophisticated algorithm for deciding
> which records need to be deleted (one that cannot be
> expressed as normal search criteria), then I suggest you
> first 'mark' the records you want to delete -- create a
> new field called 'deleteMe', and default it to 0 (or
> false), then any time you want to delete a record, set
> that field to 1 (or true). Then, once you have marked
> all the records you want to delete, execute a single
> [delete] with search criteria deleteMe=1
Hmmm, that's precisely what my posted solution does!
It marks the records to be deleted by setting the daily_index field to "remove" (no additional "deleteMe" field needed) then it deletes them all at once outside the founditems context.
:)
Sincerely,
Kenneth Grome
--Boundary-01=_GzrWOricrV/Ky2k--
Kenneth Grome
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:
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Proper file locations (1997)
Test (2003)
Bad card db - *mislabled post* (1999)
typhoon... (1997)
Ticks Email Preference (2002)
Error handling for accountNum (1997)
comparison to Lasso 6 or 7 (2004)
PCS Emailer's role ? (1997)
[WebDNA] Triggers.db wiped completely blank (2011)
multi-paragraph fields (1997)
Emailer to include Human Name with email Address (2000)
[WebDNA] WebDNA Server build instructions (2019)
WebCat2 beta FTP site (1997)
weirdness in the error log (1998)
OT: Javascript help (2003)
too many nested ... problem (1997)
Friendly , quick 'security' check, please (2003)
no global [username] or [password] displayed ... (1997)
Download Question (1997)