Re: trouble updating records in database
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19045
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).The WebDNA programmer, not the software, should perform a check for the existence of the duplicate SKU, then he/she should program WebCatalog to NOT append that new record if the SKU already exists *AND* if the SKU field is actually being used as a unique record identification value.By the way, if you use [cart] to create your SKU values, you will never have to worry about this problem anyways ... so no matter what other record numbering or tracking scheme you decide to implement, you should still be using [cart] to create a new unique SKU value for each new record.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
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).The WebDNA programmer, not the software, should perform a check for the existence of the duplicate SKU, then he/she should program WebCatalog to NOT append that new record if the SKU already exists *AND* if the SKU field is actually being used as a unique record identification value.By the way, if you use
[cart] to create your SKU values, you will never have to worry about this problem anyways ... so no matter what other record numbering or tracking scheme you decide to implement, you should still be using
[cart] to create a new unique SKU value for each new record.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Kenneth Grome
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:
OT Hosting Q again. (2002)
OT: advice on Wintel server options (1998)
[WriteFile] problems (1997)
Deleting Orders (1998)
Great product and great job ! (1997)
Re:Need help... (1997)
Need help with emailer- 2 issues (1997)
Problems setting MIME Headers (1998)
Problem 2 of 2 (was: Shipping Confusion) (2000)
Tab Charactor (1997)
Variables from a long text string (2000)
No spaces allowed in text variable names ... ? (2002)
Databases inside [SHOWIF] (1998)
Not reading code (1997)
input problem (1999)
Great product and great job ! (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Duplicate Cart ID (2001)
[isfolder] and [filename] (1997)
&FieldNametype=time unnecessary? (2000)