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:
Further on formula.db failure to calculate shipCost (1997)
Forcing a NEWCART (1997)
In Digest Dijon (2000)
Do triggers work on Macs? (2000)
Server Creation - vendors (2005)
Show next 2 examples that work (1997)
Problems passing [SKU] with $Replace in 2.0 (1997)
WebCat .pdf file is still messed up... (2000)
Follow-Up: Problem upgrading from 3.0.8 to 4.0 on MSWindoze 98 / PWS (2000)
International Orders (1998)
Text limits in NT version? (1997)
Attn: Bug in GeneralStore example b15 (1997)
Problem with summary on date / inconsequent webcat behaviour (1998)
member pages (2000)
WebCat2b13MacPlugIn - more [date] problems (1997)
Problems with [Applescript] (1997)
What's wrong with this replace? (2002)
[ShowIf] if the varieable exists (1998)
WebCat2b15MacPlugin - showing [math] (1997)
Problem with umlaut (2001)