Lookup & Form Variables

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 35418
interpreted = N
texte = I am taking a formvariable into a lookup and not being able to get a match due to a space in the variable. I have tried [URL]'ing the variable but to no joy.Someone please point me in the right direction.[Lookup db=../opsmusers.db&value=[nameidcheck]&lookInField=opsmuserid&returnField=opsmuserpw¬Found=[random][random][random]]The [NameIDCheck] is the problem, if the entered value from a form on the previous page has a space in it the returned value is [random][random][random]. The lookup works if [NameIDCheck] does not have a space in it.I tried: [Lookup db=../opsmusers.db&value=[URL][nameidcheck][/URL]&lookInField=opsmuserid&returnField=opsmuserpw¬Found=[random][random][random]] but it does not work. -- Stuart TremainDigital Imaging Division The Ad-Libitum Group 48 Victoria Street North Sydney 2060 Australia Phone: +612 9959 5633 Fax: +612 9929 4146email: stuartt@adlib.com.au http://www.adlib.com.au------------------------------------------------------------- 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:

    
  1. Re: [WebDNA] lookup in tables defined in functions - =?UTF-8?Q?=20bug=3F?= (dbrooke@euca.us 2016)
  2. Re: [WebDNA] lookup in tables defined in functions - bug? (Noah Valley 2016)
  3. Re: [WebDNA] lookup in tables defined in functions - =?UTF-8?Q?bug=3F?= (dbrooke@euca.us 2016)
  4. Re: [WebDNA] lookup in tables defined in functions - bug? (Noah Valley 2016)
  5. Re: [WebDNA] lookup in tables defined in functions - bug? (Stuart Tremain 2016)
  6. Re: [WebDNA] lookup in tables defined in functions - =?UTF-8?Q?bug=3F?= (dbrooke@euca.us 2016)
  7. Re: [WebDNA] lookup in tables defined in functions - bug? (Noah Valley 2016)
  8. Re: [WebDNA] lookup in tables defined in functions - bug? (Stuart Tremain 2016)
  9. [WebDNA] lookup in tables defined in functions - bug? (Noah Valley 2016)
  10. Re: [WebDNA] Lookup serial number of purchase? (christophe.billiottet@webdna.us 2011)
  11. [WebDNA] Lookup serial number of purchase? (Jimi Sweet NYC 2011)
  12. Re: [WebDNA] Lookup inside grep?... (Govinda 2011)
  13. Re: [WebDNA] Lookup inside grep?... (William DeVaul 2011)
  14. [WebDNA] Lookup inside grep?... (=?ISO-8859-1?Q?Cristi=E1n_Tapia?= 2011)
  15. Re: [WebDNA] lookup in php ("Mr. Robert Minor Jr." 2010)
  16. [WebDNA] lookup in php (Terry Wilson 2010)
  17. Re: [WebDNA] [lookup returning nothing at all.. not even the notfound param. (Kenneth Grome 2010)
  18. Re: [WebDNA] [lookup returning nothing at all.. not even the notfound param. (Brian Fries 2010)
  19. Re: [WebDNA] [lookup returning nothing at all.. not even the notfound param. (Gil Poulsen 2010)
  20. [WebDNA] [lookup returning nothing at all.. not even the notfound param. (Govinda 2010)
  21. Re: [WebDNA] Lookup vs. Search (Kenneth Grome 2009)
  22. Re: [WebDNA] Lookup vs. Search (Frank Nordberg 2009)
  23. Re: [WebDNA] Lookup vs. Search (christophe.billiottet@webdna.us 2009)
  24. [WebDNA] Lookup vs. Search (Kenneth Grome 2009)
  25. Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (christophe.billiottet@webdna.us 2009)
  26. Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (Kenneth Grome 2009)
  27. Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (christophe.billiottet@webdna.us 2009)
  28. [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (Frank Nordberg 2009)
  29. Re: Does anyone have any Whois lookup code in WebCat? ( "Gary Krockover" 2007)
  30. Does anyone have any Whois lookup code in WebCat? ( Dale 2007)
  31. Re: Lookup within a Search ( Scott Brown 2005)
  32. Re: Lookup within a Search ( Bob Minor 2005)
  33. Re: Lookup within a Search ( "Vijay-Kumar Solanki" 2005)
  34. Re: Lookup within a Search ( 2005)
  35. Re: Lookup within a Search ( Lester 2005)
  36. Re: Lookup within a Search ( 2005)
  37. Re: Lookup within a Search ( Jesse Proudman 2005)
  38. Re: Lookup within a Search ( Donovan Brooke 2005)
  39. Re: Lookup within a Search ( 2005)
  40. Re: Lookup within a Search ( Jesse Proudman 2005)
  41. Lookup within a Search ( Lester 2005)
  42. Search question with a lookup (3 dbs) ( Palle Bo Nielsen 2004)
  43. Re(2): lookup limitation ? (laurent pladys 2003)
  44. Re: lookup limitation ? (Tim Robinson 2003)
  45. lookup limitation ? (laurent pladys 2003)
  46. Re: Inventory lookup & display... (Paul Willis 2003)
  47. Re: Inventory lookup & display... (Alan White 2003)
  48. Re: Inventory lookup & display... (Alan White 2003)
  49. Re: Inventory lookup & display... (Donovan 2003)
  50. Re: Inventory lookup & display... (Alan White 2003)
  51. Re: Inventory lookup & display... (Donovan 2003)
  52. Re: Inventory lookup & display... (WJ Starck 2003)
  53. Inventory lookup & display... (Alan White 2003)
  54. Re: lookup problem (Rob Marquardt 2002)
  55. Re: lookup problem (Inkblot Media 2002)
  56. lookup problem (Gyuri 2002)
  57. Re: IP lookup tool via tcpconnect (Sam Lewis 2002)
  58. IP lookup tool via tcpconnect (Joe D'Andrea 2002)
  59. Re: Lookup question (Jeroen de Wijn 2001)
  60. Re: Lookup question (Jeroen de Wijn 2001)
  61. Re: Lookup question (Claus Lundholm 2001)
  62. Re: Lookup question (Jeroen de Wijn 2001)
  63. Lookup question (Claus Lundholm 2001)
  64. Re: LOOKUP and Math operations (Paolo Coppo 2001)
  65. Re: LOOKUP and Math operations (Nitai @ ComputerOil 2001)
  66. LOOKUP and Math operations (Paolo Coppo 2001)
  67. Re: lookup problem (John Butler 2000)
  68. Re: lookup problem (Rodolfo de la Garza 2000)
  69. Re: lookup problem (John Butler 2000)
  70. Re: lookup problem (Rodolfo de la Garza 2000)
  71. Re: lookup problem (Rodolfo de la Garza 2000)
  72. Re: lookup problem (John Butler 2000)
  73. Re: lookup problem (Kenneth Grome 2000)
  74. lookup problem (Rodolfo de la Garza 2000)
  75. lookup problem (Rodolfo de la Garza 2000)
  76. Re: Lookup & Form Variables (Will Starck 2000)
  77. Re: Lookup & Form Variables (Stuart Tremain 2000)
  78. Re: Lookup & Form Variables (Will Starck 2000)
  79. Lookup & Form Variables (Stuart Tremain 2000)
  80. Shipping Cost lookup and calculation (Tim Robinson 2000)
  81. Re: DNS Lookup 2 (Britt T. 2000)
  82. Re: DNS Lookup 2 (Bob Minor 2000)
  83. Re: nslookup (Aaron Lynch 2000)
  84. Re: nslookup (Nicolas Verhaeghe 2000)
  85. Re: nslookup (Aaron Lynch 2000)
  86. Re: nslookup (Bob Minor 2000)
  87. Re: nslookup (Aaron Lynch 2000)
  88. Re: nslookup (Aaron Lynch 2000)
  89. Re: nslookup (Bob Minor 2000)
  90. Re: nslookup (Nicolas Verhaeghe 2000)
  91. nslookup (Aaron Lynch 2000)
  92. Re: DNS Lookup 2 (Bob Minor 2000)
  93. Re: DNS Lookup 2 (Aaron Lynch 2000)
  94. Re: DNS Lookup 2 (Webcat 2000)
  95. Re: DNS Lookup 2 (Bob Minor 2000)
  96. Re: DNS Lookup 2 (Jeff Logan 2000)
  97. Re: DNS Lookup 2 (Aaron Lynch 2000)
  98. Re: DNS Lookup 2 (Kenneth Grome 2000)
  99. Re: DNS Lookup 2 (Jeff Logan 2000)
  100. Re: DNS Lookup 2 (Aaron Lynch 2000)
  101. DNS Lookup 2 (Bob Minor 2000)
  102. Re: DNS Lookup 2 (Sam Polk 2000)
  103. Re: DNS Lookup 2 (Sam Polk 2000)
  104. Re: lookup command (Jan Kinzler 1999)
  105. Re: lookup command (Dave MacLeay 1999)
  106. lookup command (Jan Kinzler 1999)
  107. Re: Lookup command (Kenneth Grome 1998)
  108. Lookup command (RH Prouty 1998)
  109. Re: Lookup command (Bob Minor 1998)
  110. Re: Lookup Notfound (Jay Van Vark 1998)
  111. Re: Lookup Notfound (Bob Mosebar 1998)
  112. Re: Lookup Notfound (Kenneth Grome 1998)
  113. Re: Lookup Notfound (Bob Minor 1998)
  114. Re: Lookup Notfound (Grant Hulbert 1998)
  115. Re: Lookup Notfound (Kenneth Grome 1998)
  116. Re: Lookup Notfound (Kenneth Grome 1998)
  117. Re: Lookup Notfound (Bob Minor 1998)
  118. Re: Lookup Notfound (Bob Minor 1998)
  119. RE: Lookup Notfound (Olin 1998)
  120. Re: Lookup Notfound (Kenneth Grome 1998)
  121. Lookup Notfound (bob 1998)
  122. Search or Lookup before Append (Dave Herriman 1998)
  123. Re: LookUp Tag (Pat McCormick 1997)
  124. RE: LookUp Tag (Paul Keen 1997)
  125. Re: LookUp Tag (Ray Hatch 1997)
  126. LookUp Tag (Paul Keen 1997)
  127. Price lookup problem - was Re: Cart questions (Paul Winchester 1997)
  128. Re: lookup and two records? (Kenneth Grome 1997)
  129. Re: lookup and two records? (Grant Hulbert 1997)
  130. lookup and two records? (Olin 1997)
  131. Re: lookup command (Kenneth Grome 1997)
  132. shipping calculations, lookup command (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997)
  133. Re: default value from Lookup (was Grant, please help me) (Kenneth Grome 1997)
  134. Re: default value from Lookup (was Grant, please help me) (Grant Hulbert 1997)
  135. Re: default value from Lookup (was Grant, please help me) (Kenneth Grome 1997)
  136. Re: default value from Lookup (was Grant, please help me) (Grant Hulbert 1997)
  137. Re: default value from Lookup (was Grant, please help me) (Kenneth Grome 1997)
  138. Re: default value from Lookup (was Grant, please help me) (Grant Hulbert 1997)
  139. Re: default value from Lookup (was Grant, please help me) (Kenneth Grome 1997)
  140. Re: default value from Lookup (was Grant, please help me) (Grant Hulbert 1997)
  141. Re: Associative lookup style? + bit more (Grant Hulbert 1997)
  142. Re: Associative lookup style? + bit more (w curt eggemeyer 1997)
  143. Re: Associative lookup style? + bit more (Grant Hulbert 1997)
  144. Re: WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (Grant Hulbert 1997)
  145. Re: Associative lookup style? + bit more (w curt eggemeyer 1997)
  146. WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (Sven U. Grenander 1997)
  147. Re: Associative lookup style? (Grant Hulbert 1997)
  148. Associative lookup style? (w curt eggemeyer 1997)
I am taking a formvariable into a lookup and not being able to get a match due to a space in the variable. I have tried [url]'ing the variable but to no joy.Someone please point me in the right direction.[Lookup db=../opsmusers.db&value=[nameidcheck]&lookInField=opsmuserid&returnField=opsmuserpw¬Found=[random][random][random]]The [NameIDCheck] is the problem, if the entered value from a form on the previous page has a space in it the returned value is [random][random][random]. The lookup works if [NameIDCheck] does not have a space in it.I tried: [Lookup db=../opsmusers.db&value=[url][nameidcheck][/URL]&lookInField=opsmuserid&returnField=opsmuserpw¬Found=[random][random][random]] but it does not work. -- Stuart TremainDigital Imaging Division The Ad-Libitum Group 48 Victoria Street North Sydney 2060 Australia Phone: +612 9959 5633 Fax: +612 9929 4146email: stuartt@adlib.com.au http://www.adlib.com.au------------------------------------------------------------- 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/ Stuart Tremain

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:

[append] (1997) [addlineitems] (1997) WebCat b13 CGI -shownext- (1997) (slightly off) using menu and [search] (1998) Best Platform (2000) Queertrons? (1997) [Q] Novice's question (1997) Remove me from your list immeadiately (1998) [WebDNA] Paypal Cert (2015) Replace Statement (1997) a search based on ^(contains) (1998) Re2: frames & carts (1997) WC2.0 Memory Requirements (1997) Error:Too many nested [xxx] contexts (1997) Change to UPPERCASE (2000) Copyright ? (1997) Pricing (1998) SiteGuard Admin Feature ? (1997) SetHeader Requirements (2002) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)