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:
>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:
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]
P3P and IE 6 (2004)
Newbie questions (1999)
set header in DB (no cart) (2003)
Problems reading files created by WC (1997)