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/Ky2k Content-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=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 Content-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/Ky2k Content-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=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 Content-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)