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:

Uniqueness of [cart] - revisited (2004) [sendmail] and [formvariables] (1997) NT Photo manip. util. needed (2000) Really need a answer (1999) RE: [WebDNA] Passing a text variable via copyfile (2019) Re:Emailer and encryption (1997) minimalist shopping cart. (1997) [hideif] (1998) search double negative comparison (2001) Random Order Sort? (2000) [WebDNA] grep again (2010) PLEASE REMOVE MY EMAIL ADDRESS (1997) Out of the woodwork (2007) webcatalog developers in W. Pa. (1998) Tip for making barcharts (1997) OT: Site Downloaders (2002) WebCat2 several catalogs? (1997) Req: Array Tags Explained, simple and clear (2004) mySQL GROUP BY Aggregate Function Problem (2005) Professional WebDNA Hosting Solutions (2005)