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:
AW: AW: Credit card processing - UK (1997)
Anyone using WebMerchant in the UK (2000)
WebCat with WebTen (1998)
vs (1997)
addlineitems within formvariable loop (1998)
quotes and truncating? (1997)
WebDelivery: One step closer !! (1997)
WebCat2 several catalogs? (1997)
no global [username] or [password] displayed ... (1997)
[shippingtotal] still... (2002)
syntax question, not in online refernce (1997)
WebDNA creates DUPLICATE SHOPPING CART NUMBERS (2004)
[WebDNA] WebDNA Hosts (2009)
Weeks starting on Mondays (1998)
WebCat2b12 CGI Mac -- Problems propagating the cart through (1997)
Not really WebCat- (1997)
Problems with webcat 2.01 for NT (1997)
Emailer help....! (1997)
Problems searching from a FORM (1997)
[WebDNA] Check for Ending Carriage Return (2009)