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:
WC Database Format (1997)
PCS Frames-Default page is solution! (1997)
[sendmail] and [formvariables] (1997)
WebDNA 4.5 on CentOS (2006)
Email within tmpl ? (1997)
Bug or syntax error on my part? (1997)
Emailer (1997)
[input] [/input] (1997)
So Simple (2005)
[exclusivelock] (was:several people...) (2001)
Emailer help....! (1997)
Re:Sizes and colors (1999)
[WebDNA] *temp* pdf workaround - so webdna can write printable docs - postscript? (2010)
New Problem (1997)
using showpage and showcart commands (1996)
emailer (1997)
Running _every_ page through WebCat ? (1997)
More examples? (2000)
[WebDNA] Webdna and CMS (2012)
Gremlins, huh? (2000)