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

Error Lob.db records error message not name (1997) Group search doesn't work. (1997) [IpAddress] Tag (1997) New reserved words for [tags] (2000) MacOS X 10.2.2 (2002) [WebDNA] RBS World Pay (2009) Wanted: More Math Functions (or, Can You Solve This?) (1997) graphics server, SSL, Netscape 4.0 (off topic) (1998) Setting up emailer (1998) catagories (1997) TCPConnect to query for Domain expiration (2000) PCS Frames (1997) Sendmail question [Newbie] (1999) Showing unopened cart (1997) I have observed and I am gone. (1998) Modifying order output (1997) What am I missing (1997) My slower response (1997) WILDWEBCAT encrypt.tpl submission (1998) Sku numbers (1997)