Re: Lookup & Form Variables

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 35420
interpreted = N
texte = You're right!I've spent hours trying to sort that out.I put a new user into my db and it worked, there must have been a gremlin in the userid that I was trying to use.*%&#@ Happens!Thanks for your help Will. -- 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.auOn Monday, 31 July 2000, Will Starck wrote: >I made a test page with the [url]ed version and it seems to work fine, so >you might want to look elsewhere for your problem. > >Try it here ---> http://secure.tigernet.net/test/testit.tpl > >-- >Will Starck >NovaDerm Product and Technical Support >http://www.novaderm.com >techs@novaderm.com >> From: Stuart Tremain >> Reply-To: (WebCatalog Talk) >> Date: 31 Jul 2000 10:17:31 >> To: (WebCatalog Talk) >> Subject: Lookup & Form Variables >> >> 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=opsm >> userpw¬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&retur >> nField=opsmuserpw¬Found=[random][random][random]] >> but it does not work. >> >> >> >> >> -- >> Stuart Tremain >> >> Digital Imaging Division >> The Ad-Libitum Group >> 48 Victoria Street >> North Sydney 2060 Australia >> Phone: +612 9959 5633 Fax: +612 9929 4146 >> >> email: 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/ > > >------------------------------------------------------------- >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/ >------------------------------------------------------------- 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)
You're right!I've spent hours trying to sort that out.I put a new user into my db and it worked, there must have been a gremlin in the userid that I was trying to use.*%&#@ Happens!Thanks for your help Will. -- 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.auOn Monday, 31 July 2000, Will Starck wrote: >I made a test page with the [url]ed version and it seems to work fine, so >you might want to look elsewhere for your problem. > >Try it here ---> http://secure.tigernet.net/test/testit.tpl > >-- >Will Starck >NovaDerm Product and Technical Support >http://www.novaderm.com >techs@novaderm.com >> From: Stuart Tremain >> Reply-To: (WebCatalog Talk) >> Date: 31 Jul 2000 10:17:31 >> To: (WebCatalog Talk) >> Subject: Lookup & Form Variables >> >> 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=opsm >> userpw¬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&retur >> nField=opsmuserpw¬Found=[random][random][random]] >> but it does not work. >> >> >> >> >> -- >> Stuart Tremain >> >> Digital Imaging Division >> The Ad-Libitum Group >> 48 Victoria Street >> North Sydney 2060 Australia >> Phone: +612 9959 5633 Fax: +612 9929 4146 >> >> email: 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/ > > >------------------------------------------------------------- >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/ >------------------------------------------------------------- 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:

newbie question about zip code search (2003) Faxing orders in place of email (1997) Snake Bites (1997) WebCat 3.04-3.07 plug-in dying on server.... (2000) Updating checkboxes made easy !!! (1998) Translator. (1998) Extended [ConvertChars] (1997) another database converted to WebDNA (1999) Mail Server Needed. (1998) Interfacing WebMerchant to www.fedex.com (1997) sku, title, price not showing up (1998) How To question on setting up downloads (1997) Re:multiple digests, please stop (1997) help with autenticate (1998) Include a big block of text (1997) WebCat2 - Getting to the browser's username/password data (1997) Removing [showif] makes a big difference in speed (1997) NT b19 sends extra MIME headers (1997) [index] (1997) re: [addlineitem] working almost (1997)