Re: Projects & Contractors
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12883
interpreted = N
texte = >I'll have a database for the projects and a separate database for the >contractors. The contractor database will use a simple, sequential sku >numbering (or lettering) for each record. The project database will >include a field containing all the sku numbers of the contractors >involved with that particular project. > >How do I parse this field? Should I create individual fields to hold >each contractor, and then do an indexed search using >contractor[counter]?I think it's better to create a 3rd related database that has the project SKUs and the contractor SKUs related to each other:ProjID Contractor Proj001 AAA Proj001 BBB Proj001 EEE Proj002 AAA Proj002 GGGThis shows that Project 1 has AAA, BBB, EEE bidding on it, and Project 2 has AAA, GGG bidding on it.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>I'll have a database for the projects and a separate database for the >contractors. The contractor database will use a simple, sequential sku >numbering (or lettering) for each record. The project database will >include a field containing all the sku numbers of the contractors >involved with that particular project. > >How do I parse this field? Should I create individual fields to hold >each contractor, and then do an indexed search using >contractor[counter]?I think it's better to create a 3rd related database that has the project SKUs and the contractor SKUs related to each other:ProjID Contractor Proj001 AAA Proj001 BBB Proj001 EEE Proj002 AAA Proj002 GGGThis shows that Project 1 has AAA, BBB, EEE bidding on it, and Project 2 has AAA, GGG bidding on it.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Grant Hulbert
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:
new WebDNA 5 command reference (2003)
Date Bug (1998)
[DOS]/DOS query - ANOTHER SOLUTION (2003)
Math inside [showif] (1998)
using showpage and showcart commands (1996)
Reversing [ipaddress] normalization (1998)
[WebDNA] [ReturnRaw] problem (2010)
Share cost of training videos! (1998)
includes and cart numbers (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)
NewCart+Search with one click ? (1997)
webcat- multiple selection in input field (1997)
japanese characters (1997)
FEW QUESTIONS (1997)
RE: new cart IDs being assigned somehow (1997)
Linux vs Jaguar (OSX) (2002)
$Replace with [founditems] (1997)
WebCatalog for guestbook ? (1997)
Please post more "exceptions to the rules" ... (2005)
Bookmarked URL with cart (1998)