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:
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:
FTP FOLDER PERMISSIONS (2004)
Looking for a Manual (1997)
Snake Bites (1997)
Append error (2002)
math on date? (1997)
Just Testing (1997)
RSS Feeds; basic info (2005)
Sort Order on a page search (1997)
Price question (1998)
Problem with broken images (2004)
Generating Report Totals (1997)
Verifying SSL on Page (2002)
Help! WebCat2 bug (1997)
Setting up WebCatalog with Retail Pro data (1996)
Setting a null value for reply to address using sendmail... (2001)
pull downs (1997)
[WebDNA] Digest from talk@webdna.us (2013)
Generating unique SKU from [cart] - FIXED! (1997)
WC Database Format (1997)
[WebDNA] CICADA (2009)