Re: Help with database strategy
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18070
interpreted = N
texte = >Doesn't WebCat have a 100 field limit? Does anyone have any better ideas on >how to accomplish this?No, there is no limit to the number of fields. There is no limit to the number of databases either, contrary to some misunderstood docs.You may find that a single field can hold a lot of information; for instance, a single 365-character field can represent every day of the year, where a T in position 67 means the room is available on day 67 of the year. But depending on your searching needs, that may not be prudent. If every room has 400 different amenities, then you may indeed need 400 fields. But somehow I think those amenities are broken down into broad categories that fit into relations better.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>Doesn't WebCat have a 100 field limit? Does anyone have any better ideas on >how to accomplish this?No, there is no limit to the number of fields. There is no limit to the number of databases either, contrary to some misunderstood docs.You may find that a single field can hold a lot of information; for instance, a single 365-character field can represent every day of the year, where a T in position 67 means the room is available on day 67 of the year. But depending on your searching needs, that may not be prudent. If every room has 400 different amenities, then you may indeed need 400 fields. But somehow I think those amenities are broken down into broad categories that fit into relations better.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
What's the grep? (2004)
Another pair of eyes?? (2006)
[WebDNA] [announce] WebDNA 6.2.1x (2012)
Correlating the record found with the fieldname (2000)
BBEdit and WebCatalog 2.0? (1997)
Text data with spaces in them... (1997)
Email within tmpl ? (1997)
WCS Newbie question (1997)
Adding a donation amount (2000)
Non-technical messages ... (1997)
Sort Order on a page search (1997)
[WebDNA] Accepting an XML via HTTP (2013)
Database Connectivity (1999)
WebCatalog for guestbook ? (1997)
no [search] with NT (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
Google image search results (2004)
Using [Include] Context (1999)
need some help with tcpsend (2000)
Part 2 - [showif] if variable exists (1998)