Re: relational db question

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 40924
interpreted = N
texte = aha, but which is faster? both use two searches. however, replace will replace as well as append.don't know if it is more efficient command though. Donovan Christer Olsson wrote:> [snip] > The following code will find all records in my.db and add all not previous existing IDs to more.db > > [SEARCH db=my.db&neIDdata=[blank]] > [FOUNDITEMS] > [REPLACE db=more.db&eqIDdata=[id]&Append=T]ID=[id][/REPLACE] > [/FOUNDITEMS] > [/SEARCH] >-- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> Donovan Brooke <><>->ï ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------------------------------- 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: relational db question (Donovan 2002)
  2. Re: relational db question (Bob Minor 2002)
  3. Re: relational db question (Donovan 2002)
  4. Re: relational db question (Ben Swihart 2002)
  5. Re: relational db question (Christer Olsson 2002)
  6. Re: relational db question (Donovan 2002)
  7. Re: relational db question (Donovan 2002)
  8. Re: relational db question (Ben Swihart 2002)
  9. Re: relational db question (Gary Krockover 2002)
  10. Re: relational db question (Donovan 2002)
  11. Re: relational db question (Rob Marquardt 2002)
  12. Re: relational db question (marc malacarme 2002)
  13. Re: relational db question (Donovan 2002)
  14. Re: relational db question (Ben Swihart 2002)
  15. Re: relational db question (Rob Marquardt 2002)
  16. Re: relational db question (Donovan 2002)
  17. Re: relational db question (marc malacarme 2002)
  18. Re: relational db question (Anup Setty 2002)
  19. relational db question (Ben Swihart 2002)
aha, but which is faster? both use two searches. however, replace will replace as well as append.don't know if it is more efficient command though. Donovan Christer Olsson wrote:> [snip] > The following code will find all records in my.db and add all not previous existing IDs to more.db > > [SEARCH db=my.db&neIDdata=[blank]] > [founditems] > [REPLACE db=more.db&eqIDdata=[id]&Append=T]ID=[id][/REPLACE] > [/FOUNDITEMS] > [/SEARCH] >-- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> Donovan Brooke <><>->ï ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------------------------------- 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/ Donovan

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:

Document Contains No Data! (1997) help with duplicate records posted (1998) Running _every_ page through WebCat ? (1997) WebCat2b12plugin - [search] is broken ... not! (1997) test (2004) Languages (1997) [isfolder] and [filename] (1997) Cancel Subscription (1996) Is this possible, WebCat2.0 and checkboxes (1997) Multiple Sendmail Tags on One Page (2008) Preloading code? (2002) OT: 800x600 (2003) Emailer port change (1997) FM and Webcat together? (1998) the comparison character \ (2000) [SearchString] problem with [search] context (1997) Sort Order on a page search (1997) Error Lob.db records error message not name (1997) To Err or Not Custom Error (1999) cart file creation (2003)