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:
> 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)