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:

    can pull down menu do a ONCHANGE= without Java script? (2000) OT JavaScript question (1999) Nested search (1997) best way to test for the existence of a parameter in a url (2003) Shopping Cart ID (1998) select multiple 2 more cents (1997) Cyberstudio and WebDNA (1997) a search based on ^(contains) (1998) Merging databases (1997) (2000) Nested tags count question (1997) Separate server for jpg/gif files (1998) WebCat2b12 CGI Mac - [shownext] problem (1997) Javascript and Pull Down menus (1999) Custom Shipping Charges (1997) NT - Thanks and Taxes (1997) Ok here is a question? (1997) Lookup question (2001) Re:2nd WebCatalog2 Feature Request (1996) New Web Site Developers Database (1996)