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:
Out of the woodwork (2007)
WC2b15 File Corruption (1997)
WCS Newbie question (1997)
Looking up two prices in database? (1997)
WebCat: Paying affiliates commissions?? (2000)
Initiating NewCart (1997)
PC Auth Hub+Merchant (1998)
WebCat2: multiple currency support (1997)
protect tag on NT IIS (1997)
Renaming TextA (1998)
[SMSI] WebDNA is too good to go away! (2006)
wecat crashing IIS 4 (2001)
search multiple fields from one input (1998)
Adding Items to Cart (2003)
E-Mail (1998)
Issue with plug-in Webcat, webstar 4.x, SSL and IE when using the backbuttom (2000)
Caching [include] files ... (1997)
2.0 Info (1997)
WebCat2.0 [format thousands .0f] no go (1997)
Online reference (1997)