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:

    Help with Repost Data msg from form (1997) SAVECART (1997) [WebDNA] Emailer breaking format (2015) Text Areas, Sendmail and returns.... (2002) RE:ShowIf & HideIf Question? (1998) Is there an alternative to emailer? (1999) [WriteFile] problems (1997) Forbidden CGI Error (1997) Reversed words (1997) [isfile] ? (1997) Re:Emailer Set Up (1997) One Hour Email (2002) Multiple servers and Webcat (1998) Next X hits (1996) Redirection based upon form variable (was: MOOOOOO) (2000) [WebDNA]