Re: Dubble Sku's in a Database
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23585
interpreted = N
texte = >I have tried to fix the problem of dubble sku with this > >[delete db=xx.db&eqSKUdata=dubble] > >but I have had no luck if someone could please tell me what I am doing >wrong...This is a joke, right? Just in case it's not, here's why this doesn't work: eqSKUdata=dubble searches through your database for records whose SKU field is literally the word dubble (and in case anyone cares, the correct spelling is double). So assuming your database contains no records with that text, then this delete tag will not get rid of any records at all.In general, to prevent any kind of data entry you don't want, you need to set up some kind of validation to prevent bad data from getting into your database. Perhaps looking in advance for the existence of some data, then hiding the rest of the page if that data already exists.[!] This will only append if the incoming sku does not already exist [/!] [ShowIf NotFound=[Lookup db=xx.db&lookInField=sku&value=[sku]&returnField=sku¬Found=NotFound]]...do your embedded [Append] here...[/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:
>I have tried to fix the problem of dubble sku with this > >[delete db=xx.db&eqSKUdata=dubble] > >but I have had no luck if someone could please tell me what I am doing >wrong...This is a joke, right? Just in case it's not, here's why this doesn't work: eqSKUdata=dubble searches through your database for records whose SKU field is literally the word dubble (and in case anyone cares, the correct spelling is double). So assuming your database contains no records with that text, then this delete tag will not get rid of any records at all.In general, to prevent any kind of data entry you don't want, you need to set up some kind of validation to prevent bad data from getting into your database. Perhaps looking in advance for the existence of some data, then hiding the rest of the page if that data already exists.
[!] This will only append if the incoming sku does not already exist [/!] [ShowIf NotFound=[Lookup db=xx.db&lookInField=sku&value=[sku]&returnField=sku¬Found=NotFound]]...do your embedded
[append] here...[/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:
Error, 101 a DNS problem ? (1997)
Return records from another (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
how many users (2000)
[OT] What log analyzer do you use? (2000)
test (2002)
Date Help (2004)
hideif/showif causes error if wrapped around searches (2003)
Replto in [SendMail] (2000)
[ot] table gap help?!? (2001)
really wierd browser truncating (1997)
filtering extra characters from credit card numbers (2001)
New Guestbook Source (1997)
[ShowIf] and empty fields (1997)
Error Messages Returned to User (1997)
any limitations on # of users.db entries (1999)
OT:looking for developers or you wanna swap some code? (2000)
RE: Subtotal help (1997)
Multiple fields on 1 input (1997)
[input] [/input] (1997)