Re: No Wanna Duppys

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21019
interpreted = N
texte = >This is what is not working... and I thought would.... > >[HideIf [lookup >db=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU]=[SKU]] >[Append >db=catalog.txt][FormVariables][name]=[URL][value][/URL]&[/FormVariables][/Append >] >[/HideIf] > >[ShowIf [lookup >db=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU]=[SKU]] >[SKU] already exists! >[/ShowIf] > > >SInce I am on this train of thought.... what do you suppose would keep it >from working? > >It adds regardless of dups there or not.1- Are you passing the correct SKU value from the previous page? 2- Did you ever see the [SKU] already exists! in your results page? 3- Are you *sure* the lookup is actually matching an existing SKU? Lookups are case-sensitive, so you have to be careful about that if you really want to find a match using a lookup.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: No Wanna Duppys (Peter Ostry 1998)
  2. Re: No Wanna Duppys (The Mooseman 1998)
  3. Re: No Wanna Duppys (Peter Ostry 1998)
  4. Re: No Wanna Duppys (Kenneth Grome 1998)
  5. Re: No Wanna Duppys (The Mooseman 1998)
  6. Re: No Wanna Duppys (The Mooseman 1998)
  7. Re: No Wanna Duppys (Peter Ostry 1998)
  8. No Wanna Duppys (The Mooseman 1998)
>This is what is not working... and I thought would.... > >[HideIf [lookup >db=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU]=[SKU]] >[Append >db=catalog.txt][formvariables][name]=[url][value][/URL]&[/FormVariables][/Append >] >[/HideIf] > >[ShowIf [lookup >db=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU]=[SKU]] >[SKU] already exists! >[/ShowIf] > > >SInce I am on this train of thought.... what do you suppose would keep it >from working? > >It adds regardless of dups there or not.1- Are you passing the correct SKU value from the previous page? 2- Did you ever see the [SKU] already exists! in your results page? 3- Are you *sure* the lookup is actually matching an existing SKU? Lookups are case-sensitive, so you have to be careful about that if you really want to find a match using a lookup.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Kenneth Grome

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:

Summary search -- speed (1997) [OT] MacOs IE5 topmargin and leftmargin bug (2000) Performance: deafening silence (1999) [sendmail] and [formvariables] (1997) Sum of Quantities (1997) Setting up shop (1997) OT: SSL Certs (2005) [search] within [listfiles]? (2003) shipcost (1997) Setting up shop (1997) Bit off subject -- Faxing orders (1997) pop up building with summarize (1998) Formulas.db + Users.db (1997) Re:PCS Customer submissions ? (1997) Visitor info (2000) Alternating BGColors in Table Rows (1998) WebCat2b13 Command Reference Doc error (1997) [SHOWIF AND/OR] (1997) E-Mail Preferences in Admin Folder (1997) WebCommerce: Folder organization ? (1997)