Re: My Eyes doth deceive me
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 40674
interpreted = N
texte = Donovan,When ever a lookup is not finding a record that you know is there, youshould look at the case of the field names and values. Lookups are casesensitive. It's one of those things that you only remember at times likethis...PaulOn 6/18/02 10:13 AM, Donovan
wrote:> O.K., I've been on this waaaay tooo long now.> > This:> [LOOKUP> db=admin/products.db&value=[url][theSKU][/url]&lookInField=SKU&returnField=DIS> CAT¬Found=TextIfNotFound]> > Is not finding a SKU that is there!> > My tests reveil that [theSKU] is correct. (looking for WP71 and it> holds WP71) But TextIfNotFound is what is found.> > Its driving me batty. Here is the code:> > [!]...begin code...[/!]> [text]categ=[LOOKUP> db=admin/products.db&value=[url][theSKU][/url]&lookInField=SKU&returnField=DIS> CAT¬Found=TextIfNotFound][/text]> > [!]...originally had the above in the if context below but set it like> so to test...[/!]> > [if [categ]=WPD][then]> [!]...This is the path it should be going down but it isn't...[/!]> [setlineitem cart=[cart]&db=admin/products.db&index=[getchars> start=3][name][/getchars]]quantity=[value][/setlineitem]> [text]testflag=wpd[/text][/then]> [else][text]testflag=notwpd[/text]> [!]...It is going down this path :-( ...[/!]> [include file=tabledistwo.inc]> [setlineitem cart=[cart]&db=admin/products.db&index=[getchars> start=3][name][/getchars]]quantity=[newqty]&password=mypass&price=[newprice][/> setlineitem]> > [/else][/if]> > [redirect> url=[url]results.html?cart=[cart]&recalc=reassess&taxd=tegsh&theSKU=[theSKU]&s> tart=[start]&miscflag=[miscflag]&categ=[categ]#purch[/url]]> > [!]...end code...[/!]> > If anyone can see anthing I would appreciate it.> thanks, Donovan> > > --> ------------------------------------------------------------------------> > ------------------------------------------------------------------------> > <><> Donovan Brooke <><>->ï> ------------------------------------------------------------------------> > ------------------------------------------------------------------------> > > -------------------------------------------------------------> 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/___________________________________________________________________Paul Uttermohlenhttp://www.Uttermohlen.com/ (family)Web Services - site/server monitoring, hosting, server co-location,development, e-commerce, email and more5700 Saucony DriveHilliard, Ohio 43026614-529-8963 || 614-323-5146______________________________________________________________________________________________________________________________________-------------------------------------------------------------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:
Donovan,When ever a lookup is not finding a record that you know is there, youshould look at the case of the field names and values. Lookups are casesensitive. It's one of those things that you only remember at times likethis...PaulOn 6/18/02 10:13 AM, Donovan wrote:> O.K., I've been on this waaaay tooo long now.> > This:> [LOOKUP> db=admin/products.db&value=[url][theSKU][/url]&lookInField=SKU&returnField=DIS> CAT¬Found=TextIfNotFound]> > Is not finding a SKU that is there!> > My tests reveil that [theSKU] is correct. (looking for WP71 and it> holds WP71) But TextIfNotFound is what is found.> > Its driving me batty. Here is the code:> > [!]...begin code...[/!]> [text]categ=[LOOKUP> db=admin/products.db&value=[url][theSKU][/url]&lookInField=SKU&returnField=DIS> CAT¬Found=TextIfNotFound][/text]> > [!]...originally had the above in the if context below but set it like> so to test...[/!]> > [if [categ]=WPD][then]> [!]...This is the path it should be going down but it isn't...[/!]> [setlineitem cart=[cart]&db=admin/products.db&index=[getchars> start=3][name][/getchars]]quantity=[value][/setlineitem]> [text]testflag=wpd[/text][/then]> [else][text]testflag=notwpd[/text]> [!]...It is going down this path :-( ...[/!]> [include file=tabledistwo.inc]> [setlineitem cart=[cart]&db=admin/products.db&index=[getchars> start=3][name][/getchars]]quantity=[newqty]&password=mypass&price=[newprice][/> setlineitem]> > [/else][/if]> > [redirect> url=[url]results.html?cart=[cart]&recalc=reassess&taxd=tegsh&theSKU=[theSKU]&s> tart=[start]&miscflag=[miscflag]&categ=[categ]#purch[/url]]> > [!]...end code...[/!]> > If anyone can see anthing I would appreciate it.> thanks, Donovan> > > --> ------------------------------------------------------------------------> > ------------------------------------------------------------------------> > <><> Donovan Brooke <><>->ï> ------------------------------------------------------------------------> > ------------------------------------------------------------------------> > > -------------------------------------------------------------> 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/___________________________________________________________________Paul Uttermohlenhttp://www.Uttermohlen.com/ (family)Web Services - site/server monitoring, hosting, server co-location,development, e-commerce, email and more5700 Saucony DriveHilliard, Ohio 43026614-529-8963 || 614-323-5146______________________________________________________________________________________________________________________________________-------------------------------------------------------------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/
Paul Uttermohlen
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:
Forbidden CGI Error (1997)
searching for items that begin with a number (2004)
WebCatalog can't find database (1997)
Summary search -- speed (1997)
verify online (1997)
is there a global includes directory? (1998)
Jimmy (1998)
2nd WebCatalog2 Feature Request (1996)
Page Expiring again... (2006)
Transfer of data from Invoice to thank you templates (1998)
Almost a there but..bye bye NetCloak (1997)
FYI: virus alert (1996)
won't serve .tpl (2000)
Unusual characters in the db ... (2002)
LOOP and IF statements (1997)
URL for Discussion Archive (1997)
Search bug. Help (2002)
[WebDNA] High-profile WebDNA sites? (2008)
Cart Question (1998)
Can you do this??? and other stuff (1997)