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 Software eCommerce / Web Developer Tools http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Busted at the Border (John Hill 1998)
  2. Re: Busted at the Border (Dave MacLeay 1998)
  3. Re: Busted at the Border (Christer Olsson 1998)
  4. Busted at the Border (The Mooseman 1998)
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 Software eCommerce / 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)