Re: No Wanna Duppys
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21015
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. MM>At 11:40 Uhr -0800 13.11.1998, The Mooseman wrote: > >>I want to add a snip that looks at the catalog.db and sees if there is >>a matching sku number before it writes a duplicate sku to the db. >> >>Am I correct that a [showif] should handle it on the called eg:results >>page? >>I can't recall how to search for it first... with a lookup or a search.... >>no success with either! > > >Lookup is faster than search: > >[showif [lookup >db=catalog.db&value=[NewSku]&lookinfield=sku&returnfield=sku¬found=ok]=ok] >[m >ath show=f]v_add=1[/math] >[/showif] > >[showif [math]v_add[/math]=1] > (add the item...) >[/showif] >[hideif [math]v_add[/math]=1] > (this is a dup, don't add the item or use a different SKU...) >[/hideif] > >You can do a second lookup within a hideif-tag instead of setting a >variable, but doing just one lookup is supposed to be faster. > > >Peter > >++++++++++++++++++++++++++++++++++++++++++++++++ >Peter Ostry - Vienna/Austria - www.ostry.com >Fon ++43-1-877 74 54 Fax ++43-1-877 74 54-21 >++++++++++++++++++++++++++++++++++++++++++++++++
Associated Messages, from the most recent to the oldest:
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. MM>At 11:40 Uhr -0800 13.11.1998, The Mooseman wrote: > >>I want to add a snip that looks at the catalog.db and sees if there is >>a matching sku number before it writes a duplicate sku to the db. >> >>Am I correct that a
[showif] should handle it on the called eg:results >>page? >>I can't recall how to search for it first... with a lookup or a search.... >>no success with either! > > >Lookup is faster than search: > >[showif [lookup >db=catalog.db&value=[NewSku]&lookinfield=sku&returnfield=sku¬found=ok]=ok] >[m >ath show=f]v_add=1[/math] >[/showif] > >[showif
[math]v_add[/math]=1] > (add the item...) >[/showif] >[hideif
[math]v_add[/math]=1] > (this is a dup, don't add the item or use a different SKU...) >[/hideif] > >You can do a second lookup within a hideif-tag instead of setting a >variable, but doing just one lookup is supposed to be faster. > > >Peter > >++++++++++++++++++++++++++++++++++++++++++++++++ >Peter Ostry - Vienna/Austria - www.ostry.com >Fon ++43-1-877 74 54 Fax ++43-1-877 74 54-21 >++++++++++++++++++++++++++++++++++++++++++++++++
The Mooseman
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:
Installing on IIS 5.1 Windows XP Pro - Username/Password (2006)
Success Stories (1997)
Help! WebCat2 bug (1997)
Summary search -- speed (1997)
Help formatting search results w/ table (1997)
creator code (1997)
Webcatalog Future?!? (2000)
More e-mail testing... (2000)
showif comparison begins w/ and contains (1997)
Random tags HELP!!!! (1999)
WebCat2: Formulas.db question (1997)
Nested tags count question (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Bulk Processing Offline (2004)
RE: IIS4b2 and WebCatalog b19 (1997)
WebCat2final1 crashes (1997)
E-Mail Preferences in Admin Folder (1997)
Help!HELP!HELP! (1999)
Cleaning strings for SQL with WebCat (2005)
OT: Non US IP #'s (2003)