relational db question

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 40902
interpreted = N
texte = 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] ------------------------------------------------------------- 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)
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] ------------------------------------------------------------- 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/ Ben Swihart

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:

[WebDNA] search command problem (2009) RE: Upload (1998) [WebDNA] [OT] the "Work in progress" thread. (2009) FW: WebDNA-Talk searchable? (1997) user selectable sort order (2000) UPS problems (again) (2000) I give up!! (1997) back one? (2000) Garbage files created -METOO (2000) Comments in db? (1997) WebMerchant 1.6 and SHTML (1997) RE: Formulas.db + Users.db (1997) Just Testing (1997) Weird Linux WebCat Issue (2003) Multiple catalog databases and showcart (1997) Show shoppingcart after remove last item (1997) [TaxableTotal] - not working with AOL and IE (1997) Date Sorting (1997) Searching/sorting dates (1997) Problems with upload / WebCat (1998)