Re: Busted at the Border
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20710
interpreted = N
texte = Remember, [lookup] is case sensitive, and [search], by default, isn't. Thus it's possible that one may not find the record even if it's there. Your logic looks a bit wrong since you're not comparing the results of the [lookup] to anything and there isn't a found parameter. Also, You're showing the text already exists when you add the record (which should be the opposite I think).Try something like:[showif[lookup db=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU&NotFound=]=][sku] doesn't exist![Append db=catalog.txt][FormVariables][name]=[URL][value][/URL]&[/FormVariables][/Append][/showif]John.>[hideif>[lookupdb=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU&Found=[sku]]]>[sku] already exists!>[Append>db=catalog.txt][FormVariables][name]=[URL][value][/URL]&[/FormVariables][/Append>]>[/hideif]>>>Mooseman John A. Hill, V.P. Marketing Pacific Coast SoftwareeCommerce / Web Developer Tools http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
Remember,
[lookup] is case sensitive, and
[search], by default, isn't. Thus it's possible that one may not find the record even if it's there. Your logic looks a bit wrong since you're not comparing the results of the
[lookup] to anything and there isn't a found parameter. Also, You're showing the text already exists when you add the record (which should be the opposite I think).Try something like:[showif[lookup db=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU&NotFound=]=][sku] doesn't exist![Append db=catalog.txt]
[formvariables][name]=
[url][value][/URL]&[/FormVariables][/Append][/showif]John.>[hideif>[lookupdb=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU&Found=[sku]]]>[sku] already exists!>[Append>db=catalog.txt]
[formvariables][name]=
[url][value][/URL]&[/FormVariables][/Append>]>[/hideif]>>>Mooseman John A. Hill, V.P. Marketing Pacific Coast SoftwareeCommerce / Web Developer Tools http://www.smithmicro.com
John Hill
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:
[WebDNA] 30 Minute Cookies (2016)
Emailer choke (1997)
2.0 Info (1997)
NT considerations (1997)
SAVECART (1997)
Multiple prices (1997)
Converting SQL Microtime to Date and Time (2003)
users change an email address (2002)
tricky embedded[showifs/hideifs] (w/ code.. long) (2000)
Error 551 in Emailer (2000)
Using [redirect] in the middle of a page? (1999)
RE: New WebCatalog Version !!! (1997)
Changing in a founditems tag (1999)
Adding new customer numbers sequentially (1997)
Cart Numbers (1997)
[WebDNA] Forum using Webdna (2009)
WC2.0 Memory Requirements (1997)
SKU lookup (1997)
Re1000001: Setting up shop (1997)
Credit card processing options. . . (1997)