Re: No Wanna Duppys
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21016
interpreted = N
texte = This is what is not working... and I thought would....[HideIf [lookupdb=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU]=[SKU]][Appenddb=catalog.txt][FormVariables][name]=[URL][value][/URL]&[/FormVariables][/Append][/HideIf][ShowIf [lookupdb=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 itfrom 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 [lookupdb=catalog.txt&value=[SKU]&lookinfield=SKU&returnfield=SKU]=[SKU]][Appenddb=catalog.txt]
[formvariables][name]=
[url][value][/URL]&[/FormVariables][/Append][/HideIf][ShowIf [lookupdb=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 itfrom 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:
PSC recommends what date format yr 2000??? (1997)
WebCatalog for Postcards ? (1997)
BBEdit and WebCatalog 2.0? (1997)
Applescript, WebDNA, and PDF (1997)
Remove (2000)
[SearchString] usage (1997)
last word listed (2000)
Where is f2? (1997)
Price Not Appearing (2000)
Problems getting parameters passed into email. (1997)
Trouble with Netscape (1998)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
SiteGuard Use Question (1997)
Removing [showif] makes a big difference in speed (1997)
WebDNA and Virtual Servers (2003)
[WebDNA] Barcode (2014)
RE: protect tag not working (1998)
[searchString] (1997)
WebCatalog/WebMerchant 2.1 (1998)
More on the email templates (1997)