[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:

[addlineitems] display (1997) Has anyone built this already? (2003) [lookup] is case-sensitive, [lookup] is case sensitive... (2003) New One (for me).... Error type 12 (1999) OS X, Running WebDNA in different directory (2005) Protect vs Authenicate (1997) webcat & permissions (1999) [WebDNA] Local Development On Windows 8.1 (2015) Sort Order on a page search (1997) Show if time tags (1997) TCPConnect (2005) emailer error -108 (1997) in conversions.db crashes unix webcat (1999) WebDNA Grep help wanted (2004) Emailer help....! (1997) Monthly Reports (2000) Mac Vs WindowsNT (1997) PSC recommends what date format yr 2000??? (1997) Search results templates (1996) my price won't move (1997)