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