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:
Can [writefile] files be served thru webcat? (2000)
Using Plug-In while running 1.6.1 (1997)
RE: Emailer on NT! (1998)
Separate SSL Server (1997)
log out (2001)
alternatives for WebDNA (2004)
Date Sorting (1997)
WebCatalog Technical Reference (1997)
WCS Newbie question (1997)
Reversed words (1997)
Using Applescript to process WebCatalog functions (1998)
WebCat2b13MacPlugIn - syntax to convert date (1997)
Text data with spaces in them... (1997)
Hyperboard/bulletin board available (1998)
Webdna is dead! (2003)
OR-searching (2000)
Problem displaying search result (1997)
A quickie question (1997)
WebCat for Unix?? (1997)
Mac 2.1b4 unknown error: BadSuffix (1997)