Re: relational db question
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 40906
interpreted = N
texte = you got the right idea...-----[text]count=0[/text][search db=my.db&neIDdatarq=find_all][founditems][text]theID=[ID][/text][search db=more.db&eqIDdatarq=[ID][showif [numfound]=0][append db=more.db]ID=[ID][/append][text]count=[count]+1[/text][/showif][/search][/founditems][/search]There were [count] items added to more.db.----DonovanBen Swihart wrote:> Ok, my.db may have id's that are not in more.db. If so, I want to> append these records (just the ID field) to the more.db. Otherwise, I> want to ignore the id's in my.db... If a record exists in more.db that's> in my.db, then SKIP - how?>> [search db=my.db&eqIDdata=123][founditems]>> Hey you, the ID is [id]!>> [search db=more.db&eqIDdata=[id]][founditems]>> ..... If ID record 123 isn't in more.db, then I want to append it.....> If it's already IN there, then I want to ignore and move on.>> [append db=more.db]id=[id][/append]>> [/founditems]> [/search]>> Your record has been checked!>> [/founditems]> [/search]>> Ben Swihart, Web Designer and SysAdmin> Gotricities Network> (423) 392-1123 [work]> (423) 292-9063 [cell]>> ------------------------------------------------------------->-- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> 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:
you got the right idea...-----[text]count=0[/text][search db=my.db&neIDdatarq=find_all][founditems][text]theID=[ID][/text][search db=more.db&eqIDdatarq=[ID][showif [numfound]=0][append db=more.db]ID=[ID][/append][text]count=[count]+1[/text][/showif][/search][/founditems][/search]There were [count] items added to more.db.----DonovanBen Swihart wrote:> Ok, my.db may have id's that are not in more.db. If so, I want to> append these records (just the ID field) to the more.db. Otherwise, I> want to ignore the id's in my.db... If a record exists in more.db that's> in my.db, then SKIP - how?>> [search db=my.db&eqIDdata=123][founditems]>> Hey you, the ID is [id]!>> [search db=more.db&eqIDdata=[id]][founditems]>> ..... If ID record 123 isn't in more.db, then I want to append it.....> If it's already IN there, then I want to ignore and move on.>> [append db=more.db]id=[id][/append]>> [/founditems]> [/search]>> Your record has been checked!>> [/founditems]> [/search]>> Ben Swihart, Web Designer and SysAdmin> Gotricities Network> (423) 392-1123 [work]> (423) 292-9063 [cell]>> ------------------------------------------------------------->-- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> 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:
syntax question, not in online refernce (1997)
Email notification to one of multiple vendors ? (1997)
Re:quit command on NT (1997)
When is unitShipCost calculated? (1998)
Email notification to one of multiple vendors ? (1997)
Strange search/writefile issue (2004)
merchant accts. (1997)
Requiring that certain fields be completed (1997)
redirect within the ErrorMessages.db (2003)
Searchable WebCat (etc.) Docs ? (1997)
numfound=0 for a search after going into the SSL (2003)
failure to encrypt (or maybe decrypt) (1999)
Sort Order on a page search (1997)
billing system (2003)
Beta 18 (1997)
WebCat2 several catalogs? (1997)
Summary search -- speed (1997)
PSC recommends what date format yr 2000??? (1997)
[SHOWIF]s and empty arguments (1997)
New iMac, now ... how do I make webdna serve .html files? (2005)