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:
Add more fields to an existent data base (1997)
The [shownext] limitations (2002)
Problems with [Search] param - Mac Plugin b15 (1997)
How To question on setting up downloads (1997)
Newbie problem blah blah blah (1997)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
SKU lookup (1997)
Next X hits (1996)
HTML Editors (1997)
Netscape 3.01 can't see db in form (was problems problemsproblems) (1997)
ssl/empty cart problem (2003)
Layers,Dreamweaver and WebCat Code (2000)
[Webcat 2]Next (1997)
Next X hits (1996)
Browser Resolution (1999)
Running _every_ page through WebCat ? (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
[math date]: Arrrggh! (2003)
Show shoppingcart after remove last item (1997)
HTML Editors (1997)