Re: relational db question
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 40903
interpreted = N
texte = [search db=my.db&eqIDdata=123] [founditems] [search db=more.db&eqIDdata=[id]] [showif [numfound]=0] [append db=more.db]id=[id][/append] [/showif] [/search] [/founditems] [/search]HTH- Anup Setty ----- Original Message ----- From: Ben Swihart
To: WebCatalog Talk Sent: Tuesday, June 25, 2002 2:29 PM Subject: relational db question > 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/ > ------------------------------------------------------------- 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:
[search db=my.db&eqIDdata=123] [founditems] [search db=more.db&eqIDdata=[id]] [showif [numfound]=0] [append db=more.db]id=[id][/append] [/showif] [/search] [/founditems] [/search]HTH- Anup Setty ----- Original Message ----- From: Ben Swihart To: WebCatalog Talk Sent: Tuesday, June 25, 2002 2:29 PM Subject: relational db question > 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/ > ------------------------------------------------------------- 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/
Anup Setty
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:
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
Changing user submitted data (2000)
Re:Merging databases (1997)
Nested tags count question (1997)
WebDNA on Fedora 5 -Apache won't start (2006)
Problems with Price field (1997)
setting taxable to true (1997)
Access Denied! But why? (1997)
Store Builder (2000)
Bug alert! (1997)
New Problem (1997)
[username][password] not showing up! HELP! (1999)
How to append text after the sign & (1997)
[WebDNA] eCommerce in 7.0 but not in 7.1? (2012)
HMAC-MD5 hash -- what the... (2003)
New (1998)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Nested search (1997)
Separate SSL Server (1997)