Re: relational db question

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 40916
interpreted = N
texte = Why do you have this line: [text]theID=[ID][/text]When you don't call [theID] at any point? -----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Gary Krockover Sent: Tuesday, June 25, 2002 3:56 PM To: WebCatalog Talk Subject: Re: relational db question Also, add the missing bracket: [search db=more.db&eqIDdatarq=[ID]] <-- closing searchGK> 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/ ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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)
Why do you have this line: [text]theID=[ID][/text]When you don't call [theID] at any point? -----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Gary Krockover Sent: Tuesday, June 25, 2002 3:56 PM To: WebCatalog Talk Subject: Re: relational db question Also, add the missing bracket: [search db=more.db&eqIDdatarq=[ID]] <-- closing searchGK> 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/ ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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] New Licenses (2009) possible, WebCat2.0 and checkboxes-restated (1997) Can you do this??? and other stuff (1997) [OT] Domain Name Scam (2000) Mozilla/4. and Browser Info.txt (1997) WebCatalog not recognizing ShoppingCarts folder (2000) [OT] Looking for WC web dev help (2003) Need formum software... (2003) Re:2nd WebCatalog2 Feature Request (1996) questions on variations of Ken's [text multi=T]var1=&var2=[/text] (1999) Include an include file as raw webDNA (2002) boldwords funky (1998) Need Sample Template - just purchased (1997) Requiring that certain fields be completed (1997) Off Topic: Sound Clips (2003) Deleting with contexts (2001) UPPERCASE (1997) New Weird Behavior (bug report) (2000) WebCat Mac OS X and Encrypt Help Need (2000) WC2b15 - [HTMLx]...[/HTMLx] problems (1997)