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:
Database Updates (1997)
Forumulas.db & Variables (2002)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
OSX 10.1.1 (2001)
Checking for WebCatalog Version (2000)
Card clearance, problems - solutions? (1997)
empty shopping cart message (1997)
User/pass with tcpconnect (2000)
Dynamic Generation of PDFs? (2003)
Sorting by SKU Not Working (1998)
Cookies (1999)
Dummy Credit Card Number for debug? (1997)
Summary layout (1997)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
[OT] 'Email this story to a friend' (2003)
[ListFiles] Within [LineItems] (2001)
RE: shrink-wrapped version out yet? (1997)
[movefile] prob *solved* (2005)
E-mail Attachments (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)