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.----Donovan Ben 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:

    
  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)
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.----Donovan Ben 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:

Help w/ Duplicating The General Store 5 times. (1997) RE:It just Does't add up!!! (1997) OT: Amazon Patents (2000) variables in [addlineitem] (1998) WebCatalog 4.0.2b5 available (2000) writefile on OSX (2004) SendMail context not working on CentOS 4 (2007) [WebDNA] Error installing WebDNA on Ubuntu (2016) Error Log (2000) Time to opensource? (2006) Leap Day Triggers? (2000) AutoReload? RequireComment? InterpretAll? (1999) Problems with Frames (1998) notification solutions (1997) [include ...] behavior (1997) 2.0 Info (1997) Change 2.0 to 2.1: Carts files not written to disk automatically (1998) Frames and WebCat (1997) ShowPage error (1998) Changes to the List (1997)