Re: Dubble Sku's in a Database
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23539
interpreted = N
texte = >Is there a way to elimite the problem with dubble skus in a database any >suggestions on how this can be doneOK, here's the general idea:1) Do a lookup into the database for the incoming sku, 2) if the sku is not found, then append the record[ShowIf NotFound=[lookup db=xx.db&lookInField=sku&value=[sku]&returnfield=sku¬Found=NotFound]] [Append db=xx.db]sku=[sku][/Append] [/ShowIf]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:
>Is there a way to elimite the problem with dubble skus in a database any >suggestions on how this can be doneOK, here's the general idea:1) Do a lookup into the database for the incoming sku, 2) if the sku is not found, then append the record[ShowIf NotFound=[lookup db=xx.db&lookInField=sku&value=[sku]&returnfield=sku¬Found=NotFound]] [Append db=xx.db]sku=[sku][/Append] [/ShowIf]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:
New command suggestion (was Modifying databases manually) (1997)
[isfile] ? (1997)
Searching multiple records for certain info (2000)
mass mailing (1998)
PCS Emailer's role ? (1997)
How long until WebDNA makes the list? :( (2004)
[SearchString] usage (1997)
WC 2.0 frames feature (1997)
% (mod) was looping table rows (1999)
[OT] md5 or sha-1 on OSX (2007)
Another question about credit cards (1997)
Solve the Problem, get the code! (2001)
Re2: Calculating multiple shipping... (1997)
Sendmail problem (2002)
Help Wanted - Stowe, Vermont (1999)
Summing fields (1997)
Trouble with formula.db (1997)
access denied problem (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Great product and great job ! (1997)