Re: [LOOKUP]

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11022
interpreted = N
texte = >Which way does WebCat perform a [LOOKUP]. Ascending or descending? Is there >a way to decide which way?For speed reasons, [Lookup] is very restrictive. It always looks from the first record to the last, and text comparisons are case-sensitive. If you need more flexibility, use [search] instead.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court, #453 | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com 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] ( )
>Which way does WebCat perform a [lookup]. Ascending or descending? Is there >a way to decide which way?For speed reasons, [lookup] is very restrictive. It always looks from the first record to the last, and text comparisons are case-sensitive. If you need more flexibility, use [search] instead.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court, #453 | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Grant Hulbert

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:

Encrypt/Decrypt (2007) Error: Too many nested [xxx] contexts (1997) default value from Lookup (was Grant, please help me) (1997) This list needs a digest: rant, rave... (1997) PIXO (1997) How true is this? (1999) SKU lookup (1997) UN-WANTED character conversion (1999) serial number not working (1998) Not really WebCat- (1997) stats (2001) WebCatalog2 Feature Feedback (1996) Banners (1997) Small problem with searching (2002) Help! WebCat2 bug (1997) Country & Ship-to address & other fields ? (1997) Multiple adding (1997) stumped on simple sort (1999) Further on formula.db failure to calculate shipCost (1997) multi-paragraph fields (1997)