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:
Verifying both name and password (was: THANKS) (1997)
Firesite cache vs webcat cache (1997)
Make sure I understand this??? (1997)
Zipcodes (1998)
Security Issues and WebCommerce Solution (1997)
Date problems-more (1997)
read and write you own cookies with webcat (1997)
How long until WebDNA makes the list? :( (2004)
HELP WITH DATES (1997)
Help! WebCat2 bug (1997)
keep W* in front applescript? (1998)
Displaying photo attached to first record (1997)
Performance of this mailserver (2000)
RE: Error: template (1997)
Error: the 'showcart' command requires that you specify a db (1997)
RE:It just Does't add up!!! (1997)
WebCatalog2 Feature Feedback (1996)
denying access to a banned username (2002)
Generating Options for a Form. (1997)
[OT] Startin' sumthin' again - Python, anyone tried it? (2006)