[WebDNA] [lookup] fails when using [url] to wrap a value for potential "&" char?

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103229
interpreted = N
texte = I am really surprised to see this behavior: This: [lookup db=^db/aaa.db&lookInField=bbb&value=[URL][ccc][/ URL]&returnField=ddd¬Found=eee] returns: eee But this: [lookup db=^db/ aaa.db&lookInField=bbb&value=[ccc]&returnField=ddd¬Found=eee] returns: the value I expect (the value for [ddd] in the found record). So then won't the latter (working) lookup break when the 'bbb' field may contain an "&" char (when we don't use [url])?! I can work around with [search].. but what if I need the speed of the [lookup]? -- Can anyone confirm this? Comment? -John 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 potential "&" char? (John Butler 2009)
  3. Re: [WebDNA] [lookup] fails when using [url] to wrap a value for potential "&" char? (Brian Fries 2009)
  4. [WebDNA] [lookup] fails when using [url] to wrap a value for potential "&" char? (John Butler 2009)
I am really surprised to see this behavior: This: [lookup db=^db/aaa.db&lookInField=bbb&value=[url][ccc][/ URL]&returnField=ddd¬Found=eee] returns: eee But this: [lookup db=^db/ aaa.db&lookInField=bbb&value=[ccc]&returnField=ddd¬Found=eee] returns: the value I expect (the value for [ddd] in the found record). So then won't the latter (working) lookup break when the 'bbb' field may contain an "&" char (when we don't use [url])?! I can work around with [search].. but what if I need the speed of the [lookup]? -- Can anyone confirm this? Comment? -John John Butler

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:

off-topic: stylesheet questions ... (2003) Future of WebDNA (was urls) (2005) Multiple Passwords (1997) Random Command (1997) [WebDNA] Google Map Mashup available at webdna.us (2010) vs (1997) [WebDNA] Range calculation w/negative values (2011) Problems appending to database (1997) HELP! 10K hits per hour for pages that no longer exist! (2000) Loops and [index] (1998) Make sure I understand this??? (1997) Re:listfiles-looking for slick solution (1997) Caching pages...again (2001) Odd linefeed problem (2003) [protect admin] (1997) shipcost (1997) Template not found error messages (1997) 2.0Beta Command Ref (can't find this instruction) (1997) WC2.0 Memory Requirements (1997) RE: MacFinder -- a new WebDNA web site (1998)