Re: Wonderin' whats the way

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 20775
interpreted = N
texte = >I want to build a database that will have a field called areas that will>contain all the areas serviceable by a company in that database and I>have a field called AREAS, what is the best way to store a list of items>ie. Philadelphia, Delaware, New Jersey. I want to be able to access this>list and do something like insert a
after each item or maybe an

>before each item. I guess this is basically an array of strings.In general what you're talking about is called a relational database, andis handled by using a separate db to hold the list of all related strings.You can see an example in the online docs under Searching/Multiple DatabasesBut if you really just want to store those strings in a single field, thenWebCatalog 3.0 has a new feature called [ListWords] that will help youbreak up a comma-delimited list (or any other delimiters) into separatechunks.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: Wonderin' whats the way (charles kline 1998) Re: Wonderin' whats the way (PCS Technical Support 1998) Wonderin' whats the way (charles kline 1998)

>I want to build a database that will have a field called areas that will>contain all the areas serviceable by a company in that database and I>have a field called AREAS, what is the best way to store a list of items>ie. Philadelphia, Delaware, New Jersey. I want to be able to access this>list and do something like insert a
after each item or maybe an

>before each item. I guess this is basically an array of strings.In general what you're talking about is called a relational database, andis handled by using a separate db to hold the list of all related strings.You can see an example in the online docs under Searching/Multiple DatabasesBut if you really just want to store those strings in a single field, thenWebCatalog 3.0 has a new feature called [listwords] that will help youbreak up a comma-delimited list (or any other delimiters) into separatechunks.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/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:

Can you do this??? and other stuff (1997) XML version of WebDNA docs? (2000) Search design (1997) Multiple Passwords (1997) credit card (1997) Serial Number Question (1997) Separate SSL Server (1997) calculating tax rates, mail order solutions and version 2 (1997) time format (2005) W* 3.x & WebCat + WebMerchant (1998) 3rd request: What are SMSI's upgrade policies? (2003) flushdatabases (1997) redirect from the errorsMessages.db entry (1997) Content search & results (2008) Resume Catalog ? (1997) web hosting (2000) Reversing [ipaddress] normalization (1998) EIMS Problems (1997) Need a Calendar System (2001) [table] strange behaviour (2003)