Re: [LookUp]

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23645
interpreted = N
texte = Hey wait. I figured it out. It was not a problem with my template (at least the way I was testing it) the problem was that i did not have the entry in the .db correctly...ooops. >>I am doing a simple [lookup], but since [UpAllNight]=T I am making what >>is probably a stupid mistake. Can anyone see it?? >> >>[HideIf [action]=Register] >>
>> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >>
Enter a name:
Enter a password:
Confirm password:
>>
>>[/HideIf] >>[ShowIf [action]=Register] >>[!]Checks to make sure both passwords are the same[/!] >>[ShowIf [__Pass]![__PassC]]You have entered 2 different passwords - Try >>again loser[/ShowIf] >>[ShowIf [__Pass]=[__PassC]] >> >>[!]Part of login.tpl[/!] >>[!]This is the line of code giving me probs[/!] >> >>[ShowIf [Lookup >>db=Users.db&Value=[__Name]&LookInField=NAME&ReturnField=NAME&NotFound=T]=T] >>Your OK[/ShowIf] >> >>[/ShowIf] >>[/ShowIf] > > >It doesn't work because of two things: > >1-Lookups are CASE-SENSITIVE but you're not forcing the [__Name] value to >be UPPERCASE in the lookup ... and even if you did, all the [__Name] >values in the db would have to be UPPERCASE to begin with. > >I have found that it's easiest to force the original entry of these values >to be all UPPERCASE characters when appended or replaced in the db, then >in the lookup you can wrap the value in an [uppercase] context to make >webcat give you the results you seek. > >2- The NotFound=T parameter should be NotFound=F to prevent the showif >from executing when the record doesn't exist. > >Sincerely, >Ken Grome >WebDNA Consultant > > > > > -- _______________________________________________________________ Charles Kline ckline@macsultants.com WebMaster - eCommerce SpecialistMacSultants Professional Solutions for Computer SystemsPhone# 609-273-3255 Fax# 609-273-3721 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] [lookup] fails when using [url] to wrap a value for potential "&" char? (John Butler 2009)
  2. Re: [WebDNA] [lookup] fails when using [url] to wrap a value for (Donovan Brooke 2009)
  3. Re: [WebDNA] [lookup] fails when using [url] to wrap a value for potential "&" char? (John Butler 2009)
  4. Re: [WebDNA] [lookup] fails when using [url] to wrap a value for potential "&" char? (Brian Fries 2009)
  5. [WebDNA] [lookup] fails when using [url] to wrap a value for potential "&" char? (John Butler 2009)
  6. Feature request: [decrypt seed=xxxxx] from [lookup] ( WJ Starck 2005)
  7. Re: [lookup] [search] Issue ( "Kenneth Grome" 2005)
  8. Re: [lookup] [search] Issue ( Mark Derrick 2005)
  9. Re: [lookup] [search] Issue ( Brian Fries 2005)
  10. Re: [lookup] [search] Issue ( "Kenneth Grome" 2005)
  11. Re: [lookup] [search] Issue ( Mark Derrick 2005)
  12. Re: [lookup] [search] Issue ( devaulw@onebox.com 2005)
  13. Re: [lookup] [search] Issue ( Mark Derrick 2005)
  14. Re: [lookup] [search] Issue ( Donovan Brooke 2005)
  15. Re: [lookup] [search] Issue ( nitai@computeroil.com 2005)
  16. [lookup] [search] Issue ( Mark Derrick 2005)
  17. Re: [Lookup] improvment [feature request] ( Donovan Brooke 2004)
  18. Re: [Lookup] improvment [feature request] ( Brian Fries 2004)
  19. [Lookup] improvment [feature request] ( Donovan Brooke 2004)
  20. Re: [lookup] again... ( Tim Robinson 2003)
  21. Re: [lookup] again... *solved* ( "Dan Strong" 2003)
  22. Re: [lookup] again... ( "Dan Strong" 2003)
  23. Re: [lookup] again... ( Joe D'Andrea 2003)
  24. [lookup] again... ( "Dan Strong" 2003)
  25. Re: [lookup] speed sales pitch ( Kenneth Grome 2003)
  26. Re: [lookup] speed sales pitch ( John Hill 2003)
  27. Re: [lookup] speed sales pitch ( John Peacock 2003)
  28. Re: [lookup] speed sales pitch ( Brian Fries 2003)
  29. Re: [lookup] speed sales pitch ( "Dan Strong" 2003)
  30. Re: [lookup] speed sales pitch ( Kenneth Grome 2003)
  31. Re: [lookup] speed sales pitch ( "Dan Strong" 2003)
  32. Re: [lookup] speed sales pitch ( Kenneth Grome 2003)
  33. Re: [lookup] speed sales pitch ( "Dan Strong" 2003)
  34. Re: [lookup] speed sales pitch ( John Peacock 2003)
  35. Re: [lookup] speed sales pitch ( "Dan Strong" 2003)
  36. Re: [lookup] speed sales pitch ( "Dan Strong" 2003)
  37. Re: [lookup] speed sales pitch ( Donovan Brooke 2003)
  38. Re: [lookup] speed sales pitch ( John Peacock 2003)
  39. [lookup] speed sales pitch ( "Dan Strong" 2003)
  40. Re: [lookup] is case-sensitive, [lookup] is case sensitive... (Dan Strong 2003)
  41. Re: [lookup] is case-sensitive, [lookup] is case sensitive... (Kenneth Grome 2003)
  42. Re: [lookup] is case-sensitive, [lookup] is case sensitive... (Dan Strong 2003)
  43. Re: [lookup] is case-sensitive, [lookup] is case sensitive... (WebCat @ Inkblot Media 2003)
  44. Re: [lookup] is case-sensitive, [lookup] is case sensitive... (WJ Starck 2003)
  45. Re: [lookup] is case-sensitive, [lookup] is case sensitive... (Dan Strong 2003)
  46. [lookup] is case-sensitive, [lookup] is case sensitive... (Dan Strong 2003)
  47. Re: Why is [lookup] case sensitive? (Charles Kline 2001)
  48. Why is [lookup] case sensitive? (Paul Uttermohlen 2001)
  49. Re: [Lookup] on secure page not returning anything (John Butler 2000)
  50. Re: [Lookup] on secure page not returning anything (John Butler 2000)
  51. Re: [Lookup] on secure page not returning anything (Michael O Shea 2000)
  52. [Lookup] on secure page not returning anything (John Butler 2000)
  53. Re: [LookUp] (charles kline 1999)
  54. Re: [LookUp] (charles kline 1999)
  55. Re: [LookUp] (Kenneth Grome 1999)
  56. More on [lookup] (charles kline 1999)
  57. [LookUp] (charles kline 1999)
  58. Re: return two fields w/ [lookup] (Peter Ostry 1998)
  59. Re: return two fields w/ [lookup] (PCS Technical Support 1998)
  60. Re: return two fields w/ [lookup] (Kenneth Grome 1998)
  61. return two fields w/ [lookup] (Charlie Romero 1998)
  62. Re: [lookup] still not working (Bob Minor 1998)
  63. [lookup] still not working (Mike Eberly 1998)
  64. RE: High ASCII inside [LOOKUP] inside [LISTWORDS] (Olin 1998)
  65. Re: High ASCII inside [LOOKUP] inside [LISTWORDS] (Michael Winston 1998)
  66. Re: High ASCII inside [LOOKUP] inside [LISTWORDS] (Michael Winston 1998)
  67. Re: High ASCII inside [LOOKUP] inside [LISTWORDS] (Gary Richter 1998)
  68. High ASCII inside [LOOKUP] inside [LISTWORDS] (Michael Winston 1998)
  69. Re: [lookup] vs. [search] (Kenneth Grome 1998)
  70. Re: [lookup] vs. [search] (Grant Hulbert 1998)
  71. [lookup] vs. [search] (Kenneth Grome 1998)
  72. Re: [LOOKUP] (Kenneth Grome 1997)
  73. [LOOKUP] (Michael Winston 1997)
  74. Re: [LOOKUP] (John Hill 1997)
  75. Re: [LOOKUP] (grichter@panavise.com (Gary Richter) 1997)
  76. Re: [LOOKUP] (Grant Hulbert 1997)
  77. Re: [LOOKUP] (John Hill 1997)
  78. [LOOKUP] (Christer Olsson 1997)
  79. [lookup] ( )
Hey wait. I figured it out. It was not a problem with my template (at least the way I was testing it) the problem was that i did not have the entry in the .db correctly...ooops. >>I am doing a simple [lookup], but since [UpAllNight]=T I am making what >>is probably a stupid mistake. Can anyone see it?? >> >>[HideIf [action]=Register] >>
>> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >>
Enter a name:
Enter a password:
Confirm password:
>>
>>[/HideIf] >>[ShowIf [action]=Register] >>[!]Checks to make sure both passwords are the same[/!] >>[ShowIf [__Pass]![__PassC]]You have entered 2 different passwords - Try >>again loser[/ShowIf] >>[ShowIf [__Pass]=[__PassC]] >> >>[!]Part of login.tpl[/!] >>[!]This is the line of code giving me probs[/!] >> >>[ShowIf [Lookup >>db=Users.db&Value=[__Name]&LookInField=NAME&ReturnField=NAME&NotFound=T]=T] >>Your OK[/ShowIf] >> >>[/ShowIf] >>[/ShowIf] > > >It doesn't work because of two things: > >1-Lookups are CASE-SENSITIVE but you're not forcing the [__Name] value to >be UPPERCASE in the lookup ... and even if you did, all the [__Name] >values in the db would have to be UPPERCASE to begin with. > >I have found that it's easiest to force the original entry of these values >to be all UPPERCASE characters when appended or replaced in the db, then >in the lookup you can wrap the value in an [uppercase] context to make >webcat give you the results you seek. > >2- The NotFound=T parameter should be NotFound=F to prevent the showif >from executing when the record doesn't exist. > >Sincerely, >Ken Grome >WebDNA Consultant > > > > > -- _______________________________________________________________ Charles Kline ckline@macsultants.com WebMaster - eCommerce SpecialistMacSultants Professional Solutions for Computer SystemsPhone# 609-273-3255 Fax# 609-273-3721 charles kline

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:

WebCat2b12 CGI Mac -- Problems propagating the cart through (1997) Multiple Merchant Accounts? (1997) [OT] "Hacker Safe" (2007) WebCat2 - many [carts] on one template page? (1997) WebCat2 - storing unformatted date data? (1997) Erotic Sites (1997) shipcost (1997) WebCatalog/WebMerchant Manuals Available (1998) Missing from Docs [folderName] (1997) CyberCash not responding (2003) math a various prices (1997) checkbox results written to a database (1999) Associative lookup style? + bit more (1997) NT or Mac (1997) Convertchars Problem (2004) [Price] (1997) Simple way to create unique SKU (1997) Candle Light Vigil (2001) Searching Multiple DBs (1997) PCS Frames-Default page is solution! (1997)