Re: relational db question

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 40905
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? > First find all ID's in more.db:[search db=my.db&neIDdata=findall] [founditems][!]----- if Id isn't found in more.db then append.--------[/!] [search db=more.db&eqIDdatarq=[id]] [Showif [numfound]=0] [founditems] [append db=more.db]id=[id][/append][!]----- Lists all id that have been added.--------[/!]ID [ID] has been added.
[/founditems] [/showif] [/search][/founditems] [/search] ------------------------------------------------------------- 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? > First find all ID's in more.db:[search db=my.db&neIDdata=findall] [founditems][!]----- if Id isn't found in more.db then append.--------[/!] [search db=more.db&eqIDdatarq=[id]] [Showif [numfound]=0] [founditems] [append db=more.db]id=[id][/append][!]----- Lists all id that have been added.--------[/!]ID [ID] has been added.
[/founditems] [/showif] [/search][/founditems] [/search] ------------------------------------------------------------- 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/ marc malacarme

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:

Is there an easier way? (1998) Paths, relative paths, webstar server setup andsecurity WebDNA-Talk@smithmicro.com (1997) (1997) Execute Applescript (1997) [OT] Software bundle for Sale! (2001) setlineiems and UnitShip Cost (2000) Another question (1997) OSX Jaguar (2002) 2nd WebCatalog2 Feature Request (1996) FW: weird problem (2004) Superfilous Characters (1998) Encrypt question. (2000) Big Databases (1997) NTbeta18 corrupted? (1997) [WebDNA] [announce] WebDNA Site and Store (2008) RE: Can't get appendfile to work (1997) Showif with an or (2003) Re: (1998) admin:admin won't work for login:password ! (1999) Bug Report, maybe (1997)