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 seta variable in the first founditems so it can not be confused with the secondfounditems.Prefixing the field names can be very helpful here, though when we do it werarely 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 MediaChief Information Officer Drawer 607800/724.8973 Fair Haven, NY 13064Alex@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:
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 seta variable in the first founditems so it can not be confused with the secondfounditems.Prefixing the field names can be very helpful here, though when we do it werarely 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 MediaChief Information Officer Drawer 607800/724.8973 Fair Haven, NY 13064Alex@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)