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:
>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:
[WebDNA] WebDNA Roll Call (2013)
Uploading out of FMP (2001)
Apache suffix mapping for .tpl (2000)
Claris HomePage messes up the code (1997)
WebDNA 5.0 Enterprise Edition (2003)
Closing databases (2003)
HTML Editors (1997)
Another question (1997)
[WebDNA] Extract a JS variable into a form input value which can (2019)
Suggestions (1998)
[WebDNA] NOT serving WebDNA, just running it locally. (2012)
docs for WebCatalog2 (1997)
webcat running as www, should that be webstar for use withwebstar? (2002)
256 character limit in URL? Kinda urgent... (2004)
WebStar Image Cache? (2003)
A little syntax help (1997)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)
Upgrading old WebCat Database Files (1997)
Setting up shop (1997)
show if date < expiry date (2002)