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, and is 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, then WebCatalog 3.0 has a new feature called [ListWords] that will help you break up a comma-delimited list (or any other delimiters) into separate chunks.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:

        
    1. Re: Wonderin' whats the way (charles kline 1998)
    2. Re: Wonderin' whats the way (PCS Technical Support 1998)
    3. 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, and is 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, then WebCatalog 3.0 has a new feature called [listwords] that will help you break up a comma-delimited list (or any other delimiters) into separate chunks.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:

    using bw in a search on a numeric field (2000) Where's Cart Created ? (1997) Problems with [Search] param - Mac Plugin b15 (1997) NT beta ReadMe missing (b12-b15) (1997) Using the sendmail command on CGate Pro (Unix) (2000) cookies and [returnraw] (1997) Separate SSL Server (1997) Alternating colors (1997) Weird problems with [SHOWIF]s (1997) Editing HTML Pages w/WCAT (1998) many-to-one problem (1998) Tables (2005) lineitems not showing when moving up a few versions (2006) My web page only... (2003) WebCat2b12plugin - [search] is broken ... not! (1997) NT or Mac (1997) [ShowIf] if the varieable exists (1998) Freeze (2003) Forms Search Questions (1997) Zip Code Lookups (1999)