Re: [LOOKUP]

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11766
interpreted = N
texte = I think you want lookInField=[sku]&returnField=[description] to be lookInField=sku&returnField=description? Putting the brackets around sku and description means WebCatalog tries to replace them with their proper value before doing the lookup. I hope this helps.John.>I can't get the [LOOKUP] tag to return anything other than NotFound text >string. I'm referencing a database that has 2 fields (sku and description). > >I've spelled the field names correctly. I have the comment >in the page. > >What's wrong?! > >[LOOKUP >db=../DB/description.db&value=94215&lookInField=[sku]&returnField=[description] >& >notFound=Sorry, there is no profile available for this item.] > >I'm using the WC plugin (f3). > >Michael > >Michael Winston *By Phone!: (503)/652/8815 x341 >Internet Coordinator *By e-mail!: michaelw@dhorse.com >Dark Horse Comics, Inc. *By web!: http://www.dhorse.com/ John A. Hill, V.P. Marketing ********************************* Pacific Coast Software * Home of the Web's best 11770 Bernardo Plaza Ct. #462 * Catalog and Merchant software San Diego, CA 92128 * http://www.smithmicro.com Phone: 619-675-1106 Fax: 675-0372 ********************************* 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] ( )
I think you want lookInField=[sku]&returnField=[description] to be lookInField=sku&returnField=description? Putting the brackets around sku and description means WebCatalog tries to replace them with their proper value before doing the lookup. I hope this helps.John.>I can't get the [lookup] tag to return anything other than NotFound text >string. I'm referencing a database that has 2 fields (sku and description). > >I've spelled the field names correctly. I have the comment >in the page. > >What's wrong?! > >[LOOKUP >db=../DB/description.db&value=94215&lookInField=[sku]&returnField=[description] >& >notFound=Sorry, there is no profile available for this item.] > >I'm using the WC plugin (f3). > >Michael > >Michael Winston *By Phone!: (503)/652/8815 x341 >Internet Coordinator *By e-mail!: michaelw@dhorse.com >Dark Horse Comics, Inc. *By web!: http://www.dhorse.com/ John A. Hill, V.P. Marketing ********************************* Pacific Coast Software * Home of the Web's best 11770 Bernardo Plaza Ct. #462 * Catalog and Merchant software San Diego, CA 92128 * http://www.smithmicro.com Phone: 619-675-1106 Fax: 675-0372 ********************************* John Hill

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:

Updated ClipText for Edit Plus 2 (2003) For those of you not on the WebCatalog Beta... (1997) syntax question, not in online refernce (1997) I'm having trouble using [url][interpret][math] together in lookup (1997) banner ad redirection page (1999) Email (1998) hidden databases (2000) Sort Order on a page search (1997) Develop on Mac - Serve on Linux (2002) FYI: Apache Module perchild (2002) WebDNA with WebStar V (2003) Conditional searching & displaying (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Grep help (2004) Up and running ... at last !! (1997) WebCat2 Append problem (B14Macacgi) (1997) Showing once on a founditems (1997) 100% CPU (2003) Using Protection =) (2003) emailer error 103 part ii (1997)