Re: multiple db's

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47398
interpreted = N
texte = On 2/4/03 12:30 PM, Brian Fries wrote:This is very true. If you have the same names in this scenario you must set a variable in the first founditems so it can not be confused with the second founditems.Prefixing the field names can be very helpful here, though when we do it we rarely prefix the SKU field.Don know why.Voodoo, old habit, stubbornness ;-=) > [search db=a.db...][founditems] > [search db=b.db...][founditems] > [name] - comes from b.db - you can't see the one from a.db here > [/founditems][/search] > [/founditems][/search] > > Basically, WebDNA searches the innermost scope for a > field/variable/lineitem field/orderfile header/formvariable/WebDNA tag > first, then moves outward to the next scope until an identifier of the > specified name is found. > > Note the oft-lamented problem incurred by the presence of a header > named date in order files, which prevents access to the WebDNA tag of > the same name when within an orderfile context. > > For my own clarity and peace of mind, I always name database fields > with a three-letter prefix indicating the database the field is from - > for example, proName for a products db and memName for a members db.Alex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: multiple db's (Gary Krockover 2003)
  2. Re: multiple db's (Kenneth Grome 2003)
  3. Re: multiple db's (Lester Emo 2003)
  4. Re: multiple db's (Alex McCombie 2003)
  5. Re: multiple db's (Brian Fries 2003)
  6. Re: multiple db's (Alex McCombie 2003)
  7. Re: multiple db's (Donovan 2003)
  8. multiple db's (Lester Emo 2003)
On 2/4/03 12:30 PM, Brian Fries wrote:This is very true. If you have the same names in this scenario you must set a variable in the first founditems so it can not be confused with the second founditems.Prefixing the field names can be very helpful here, though when we do it we rarely prefix the SKU field.Don know why.Voodoo, old habit, stubbornness ;-=) > [search db=a.db...][founditems] > [search db=b.db...][founditems] > [name] - comes from b.db - you can't see the one from a.db here > [/founditems][/search] > [/founditems][/search] > > Basically, WebDNA searches the innermost scope for a > field/variable/lineitem field/orderfile header/formvariable/WebDNA tag > first, then moves outward to the next scope until an identifier of the > specified name is found. > > Note the oft-lamented problem incurred by the presence of a header > named date in order files, which prevents access to the WebDNA tag of > the same name when within an orderfile context. > > For my own clarity and peace of mind, I always name database fields > with a three-letter prefix indicating the database the field is from - > for example, proName for a products db and memName for a members db.Alex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- 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://webdna.smithmicro.com/ Alex McCombie

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:

Where is f2? (1997) Search Context Strips URL chrs.? (1999) Re:ListFields and [name] (1997) different show next (1997) Applescript, WebDNA, and PDF (1997) Cobalt RaQ Installation (2003) Problems with ^ could be solved with [REPLACE CHARACTERS] (1997) Comments in db? (1997) PARAMETER vs. OPERATOR (was The BUG is BACK ...) (1998) Wierd problem with 3.08 WIN Version (2000) Removing [showif] makes a big difference in speed (1997) html being uncooperative (2000) Moment of Thanks (1997) [convertchars] Problem (2000) Best way to add data to .db (1999) WebCatalog 4.0.1b1 is now available (2000) Bug Report, maybe (1997) Sendmail (1997) [OT] Appropriate Signature??? (2003) multi-paragraph fields (1997)