Re: trouble updating records in database
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19049
interpreted = N
texte = >>Do you have any SKUs that are identical to others in the database? This is >>illegal, and can cause the database admin templates to be unable to update >>that record. > >May I suggest that this is a problem with WebCat. The [Append] command >should fail if the SKU already exists, that is the way all other >databases work (FileMaker, SQL, etc).We agree that it's a bug, but not so much in WebCatalog as the templates which administer the GeneralStore demo. There is nothing inherently wrong with a database that contains multiple SKUs, because SKU is just a plain old fieldname no different than any other. It so happens that the GeneralStore demo expects them to be unique.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:
>>Do you have any SKUs that are identical to others in the database? This is >>illegal, and can cause the database admin templates to be unable to update >>that record. > >May I suggest that this is a problem with WebCat. The
[append] command >should fail if the SKU already exists, that is the way all other >databases work (FileMaker, SQL, etc).We agree that it's a bug, but not so much in WebCatalog as the templates which administer the GeneralStore demo. There is nothing inherently wrong with a database that contains multiple SKUs, because SKU is just a plain old fieldname no different than any other. It so happens that the GeneralStore demo expects them to be unique.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] The scoop?!?!?! (2008)
using showpage and showcart commands (1996)
Almost There But? WebCat Keeps Changing Cart Numbers onMe! (2002)
turning every 5th line red (1998)
problems with 2 tags (1997)
New WebDNA Solutions ... (1997)
RE: Subtotal help (1997)
webcat2b12 CGI -- Date comparisons (1997)
Question re: Format command (2000)
Templates on Unix & CGI on Mac? (1997)
Problems with ^ could be solved with [REPLACE CHARACTERS] (1997)
searchable list archive (1997)
Summing results of a nested search (2006)
Re:2nd WebCatalog2 Feature Request (1996)
Refresh Database (2002)
WCS Newbie question (1997)
docs for WebCatalog2 (1997)
multiple product databases (1997)
A few questions... (1999)
NTbeta18 corrupted? (1997)