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 to trouble 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 at this 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, I needed 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. :-) D Gene 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. Brooke Systems Administrator/ Assc. Art Director Epsen Hillmer Graphics I know I'm making progress when I look at the questions I have asked 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 to trouble 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 at this 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, I needed 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. :-) D Gene 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. Brooke Systems Administrator/ Assc. Art Director Epsen Hillmer Graphics I know I'm making progress when I look at the questions I have asked 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:
Bug or syntax error on my part? (1997)
Summarizing on two fields (1998)
[WebDNA] writefile (2009)
Re:Adding Multiple files to a cart at once (1998)
Search in 2 or more catalogs (1997)
Max Record length restated as maybe bug (1997)
Help needed! (1998)
member logins database (2003)
customizing the color of user's pages (1997)
Robert Minor duplicate mail (1997)
Grep to convert characters to html entities (2006)
Search Engine questions ... (2002)
Uploading out of FMP (2001)
Virtual hosting and webcatNT (1997)
Other then credit cards-how? (1997)
Mac 2.1b4 unknown error: BadSuffix (1997)
Part Html part WebDNA (1997)
Using Plug-In while running 1.6.1 (1997)
Template Cache problem -- new plugin for ya' (2000)
[WebDNA] Is a '.webdna' suffix better? (2008)