Updating product information
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 40742
interpreted = N
texte = A client has as CSV file that has products. He goes to the web, usesour webdna online file uploader to upload his product inventory. Myquestion: Is there a way for me to only accept the NEW products? Irealize it would be easiest if the client could just overwrite thedatabase each time, but for my needs, I really need to compare the newdata with the old data:A = (Products in old data file that are also in new data file)B = (Products in old data file that are not in new data file)C = (Products in new data file that are not in old data file)Final data should be:A - B + CIn english: I want his database to only contain products that arepresent in the new uploaded file, but I don't want to overwrite any ofthe existing products that are in stock becauase they may have madeweb-only changes to them.Any idea how to approach this problem?Ben Swihart, Web Designer and SysAdminGotricities Network-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
A client has as CSV file that has products. He goes to the web, usesour webdna online file uploader to upload his product inventory. Myquestion: Is there a way for me to only accept the NEW products? Irealize it would be easiest if the client could just overwrite thedatabase each time, but for my needs, I really need to compare the newdata with the old data:A = (Products in old data file that are also in new data file)B = (Products in old data file that are not in new data file)C = (Products in new data file that are not in old data file)Final data should be:A - B + CIn english: I want his database to only contain products that arepresent in the new uploaded file, but I don't want to overwrite any ofthe existing products that are in stock becauase they may have madeweb-only changes to them.Any idea how to approach this problem?Ben Swihart, Web Designer and SysAdminGotricities Network-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Ben Swihart
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:
WebCatalog 3.0.8 is on FTP... (2000)
question: webmerchant connection (1997)
redirect not passing vars (2004)
shipping calcs (1998)
oops private message leaked into talk list (1997)
encrypt/decrypt password with authenticate (2002)
Claris HomePage messes up the code (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
RE: IIS 4 (1998)
[countWords]? (1997)
Searching multiple fields from one form field (1997)
Frames and WebCat (1997)
AAgghh!! Help, please. SSL strikes again. (1997)
Caching [include] files ... (1997)
Configuring E-mail (1997)
Migrating to NT (1997)
SetHeader (1999)
Multiple cart additions (1997)
2.0 Info (1997)
Single Link browsing (1997)