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:

b12 cannot limit records returned and more. (1997) New Plug-in and Type 11 errors (1997) WebMerchant 3.0 for Mac shipping now (1998) problem with NT beta (1997) dbQuickView 2.0 (2005) End of line control characters (2000) Webmerchant PC auth (1998) A quickie question (1997) question: back button prevention (1997) redirect with frames (1997) shipcost (1997) Convert characters (2002) Missing contexts on NT (1997) PCS Frames-Default page is solution! (1997) How flexible is Shipping? (1997) WebCatalog 2.0 b 15 mac (1997) WebCatalog2 Feature Feedback (1996) Missing custom convert.db (1998) Logical and or in [hideif] (1997) New Web Site Developers Database (1996)