Re: 2cd pare of eyes.
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39398
interpreted = N
texte = Sorry Gene, let me get a little further before I take up all you guys's time. :-) (didn't really mean totrouble shoot the logic quite yet... just syntax)Lookup was suggested to me but I decided against it since the input values come from user input and[lookup] is case sensitive. (my fields are mixed) John P. Suggested a way to get around this but atthis time I'm just going to keep on keeping on with [search] so I don't have to revamp some stuff.The idea of using eqSKUdatarq=[name] (which should be [value]) is what I tried first. however, Ineeded to perform actions on the found items of a (not equal to SKU) search. ([name]=NL)Thanks., I'll work it a little further and if I still have problems I'll come begging at that time. :-)DGene Beljaeff wrote:> Why are you using neSKUdatarq=[blank] in your search and not eqSKUdatarq=[name], or for that matter, a lookup? Also, do you only want to add the SKUs to the cart if they are ALL valid, or do you want to add only valid ones and ignore invalid ones?>> This code should do the latter...>> [showif [qo]=update]> [!]to decide if the items listed are ready to add to the cart[/!]> [!]###loop for every formvariable who's name contains 'SKU'...###[/!]> [formvariables name=SKU&exact=F]> [hideif [url][value][/url]=]> [text]valid=no[/text]> [!]###see if formvariable SKU is in products.db...###[/!]> [text]theSKU=[lookup db=admin/products.db&value=[name]&lookinfield=SKU&returnfield=SKU¬found=][/text]> [showif [theSKU]!]> [text]valid=yes[/text]> [/showif]> [showif [theSKU]=]> [text]theSKU=NL[/text] [!]<=== do you need this? ###[/!]- yes (not quite like this though)> [/showif]> [showif [valid]=yes]> [!]verifies if item is already in cart[/!]> [orderfile cart=[cart]]> [lineitems]> [showif [url][theSKU][/url]=[SKU]]> [text]incart=T[/text]> [/showif]> [hideif [incart]=T]> [text]shop=put[/text]> [/hideif]> [/lineitems]> [/orderfile]>> [!]this adds the item[/!]> [showif [shop]=put]> [addlineitem cart=[cart]&db=admin/products.db&sku=[url][theSKU][/url]][/addlineitem]> [/showif]> [/showif]> [/hideif]> [/formvariables]> [/showif]>> Gene>-- Donovan D. BrookeSystems Administrator/Assc. Art DirectorEpsen Hillmer GraphicsI know I'm making progress when I look at the questions I haveasked in the past and think to myself... how stupid was that-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Sorry Gene, let me get a little further before I take up all you guys's time. :-) (didn't really mean totrouble shoot the logic quite yet... just syntax)Lookup was suggested to me but I decided against it since the input values come from user input and[lookup] is case sensitive. (my fields are mixed) John P. Suggested a way to get around this but atthis time I'm just going to keep on keeping on with [search] so I don't have to revamp some stuff.The idea of using eqSKUdatarq=[name] (which should be [value]) is what I tried first. however, Ineeded to perform actions on the found items of a (not equal to SKU) search. ([name]=NL)Thanks., I'll work it a little further and if I still have problems I'll come begging at that time. :-)DGene Beljaeff wrote:> Why are you using neSKUdatarq=[blank] in your search and not eqSKUdatarq=[name], or for that matter, a lookup? Also, do you only want to add the SKUs to the cart if they are ALL valid, or do you want to add only valid ones and ignore invalid ones?>> This code should do the latter...>> [showif [qo]=update]> [!]to decide if the items listed are ready to add to the cart[/!]> [!]###loop for every formvariable who's name contains 'SKU'...###[/!]> [formvariables name=SKU&exact=F]> [hideif [url][value][/url]=]> [text]valid=no[/text]> [!]###see if formvariable SKU is in products.db...###[/!]> [text]theSKU=[lookup db=admin/products.db&value=[name]&lookinfield=SKU&returnfield=SKU¬found=][/text]> [showif [theSKU]!]> [text]valid=yes[/text]> [/showif]> [showif [theSKU]=]> [text]theSKU=NL[/text] [!]<=== do you need this? ###[/!]- yes (not quite like this though)> [/showif]> [showif [valid]=yes]> [!]verifies if item is already in cart[/!]> [orderfile cart=[cart]]> [lineitems]> [showif [url][theSKU][/url]=[SKU]]> [text]incart=T[/text]> [/showif]> [hideif [incart]=T]> [text]shop=put[/text]> [/hideif]> [/lineitems]> [/orderfile]>> [!]this adds the item[/!]> [showif [shop]=put]> [addlineitem cart=[cart]&db=admin/products.db&sku=[url][theSKU][/url]][/addlineitem]> [/showif]> [/showif]> [/hideif]> [/formvariables]> [/showif]>> Gene>-- Donovan D. BrookeSystems Administrator/Assc. Art DirectorEpsen Hillmer GraphicsI know I'm making progress when I look at the questions I haveasked in the past and think to myself... how stupid was that-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Donovan Brooke
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:
Database field limit? (1998)
Emailer (1997)
Newbie problem blah blah blah (1997)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)
RE: [WebDNA] smtp authentication (2008)
Log-in Scheme (2003)
slow site (2003)
Part 2 - [showif] if variable exists (1998)
WebCat2: Found Items syntax, etc. (1997)
Bad creator codes which cause access denied errormessage (1997)
Bug or syntax error on my part? (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
SSL (1998)
[WebDNA] mod_WebDNA_apache2.2.so: mach-0, but wrong architecture (2010)
Windows 2.1b2 Append Bug? (1997)
Group search doesn't work. (1997)
Creating main- and sub-category search (1997)
showif field is number (1997)
mySQL --- problem?? (2004)
WebCat2.0 [format thousands .0f] no go (1997)