Re: relational db question
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 40922
interpreted = N
texte = Is it ok to append just a single field without adding blank spaces for the others?For example.....My.db hasID FIELD1 FIELD2 1 blah blah 2 blahlah blahblahAnd More.db hasID FIELD3 FIELD4 1 blah blah So when I run this program...... More.db becomesID FIELD3 FIELD4 1 blah blah 2With the 2 record not having any blank entries for the field3 and field4. Now, I need to have some further editing ability later to add data to the 2 record's FIELD3 and FIELD4 records. Will this be possible if they don't have blank entries (no tabs)?If I have the program [replace]ID=[id]&FIELD3=&FIELD4=[/replace] then it will delete all the previous FIELD3 and FIELD4 data in the more.db. Hmmmmmm....- Ben-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Christer Olsson Sent: Tuesday, June 25, 2002 4:10 PM To: WebCatalog Talk Subject: Re: 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]The following code will find all records in my.db and add all not previous existing IDs to more.db[SEARCH db=my.db&neIDdata=[blank]] [FOUNDITEMS] [REPLACE db=more.db&eqIDdata=[id]&Append=T]ID=[id][/REPLACE] [/FOUNDITEMS] [/SEARCH]-- ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Ljusa Idéer AB S-211 37 Malmoe Fax +46 40 97 99 77 Sweden http://www.ljusaideer.se------------------------------------------------------------- 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:
Is it ok to append just a single field without adding blank spaces for the others?For example.....My.db hasID FIELD1 FIELD2 1 blah blah 2 blahlah blahblahAnd More.db hasID FIELD3 FIELD4 1 blah blah So when I run this program...... More.db becomesID FIELD3 FIELD4 1 blah blah 2With the 2 record not having any blank entries for the field3 and field4. Now, I need to have some further editing ability later to add data to the 2 record's FIELD3 and FIELD4 records. Will this be possible if they don't have blank entries (no tabs)?If I have the program [replace]ID=[id]&FIELD3=&FIELD4=[/replace] then it will delete all the previous FIELD3 and FIELD4 data in the more.db. Hmmmmmm....- Ben-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Christer Olsson Sent: Tuesday, June 25, 2002 4:10 PM To: WebCatalog Talk Subject: Re: 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]The following code will find all records in my.db and add all not previous existing IDs to more.db[SEARCH db=my.db&neIDdata=[blank]] [founditems] [REPLACE db=more.db&eqIDdata=[id]&Append=T]ID=[id][/REPLACE] [/FOUNDITEMS] [/SEARCH]-- ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Ljusa Idéer AB S-211 37 Malmoe Fax +46 40 97 99 77 Sweden http://www.ljusaideer.se------------------------------------------------------------- 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:
[Price] (1997)
Bizarre behavior texta behavior (2004)
[WebDNA] [OT] hello (2012)
To Err or Not Custom Error (1999)
Search returns all, not 20 (1997)
raw field names (2001)
Progress !! WAS: Trouble with formula.db (1997)
RAM crash (1998)
Emailer setup (1997)
no template caching (1997)
Followup question re: checksum for credit cards? (1997)
[Sum] function? (1997)
# fields limited? (1997)
Secure server question (1997)
Shopping Cart Limits? (1998)
[WebDNA] WebDNA crash and now emailer not working (2009)
WebCatalog for Postcards ? (1997)
Tcp Connect and the disappearing page (2000)
RE: Sorting error (1997)
WebCat2b13MacPlugIn - more [date] problems (1997)