Re: [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 = 103266
interpreted = N
texte = that makes sense Brian. Thanks But [ccc] was an incoming formvar, and I did not touch it before looking for its value in the [lookup]. for some unknown reason this was failing: [lookup db=^db/blah.db&lookInField=UserUsername&value=[URL][UserID][/ URL]&returnField=UserUsername¬Found=lookupNotfound] yet, this works (I am using this workaround)- [Search db=^db/blah.db&eqUserUsernamedatarq=[URL][UserID][/URL]] My guess is that the difference is in the way [url] was working (or not) in the [lookup] compared to the [search]. See the other (long) threads I started over the weekend. (This code is included from a wysiwyg syntax page.) -John On Aug 17, 2009, at 9:59 AM, Brian Fries wrote: > John, > > I url the values in lookups all the time. > > The behavior you see could be explained if [ccc] already contains a > url'ed value. For example: > > [text]ccc=[url]&[/url][/text] > [lookup db=^db/aaa.db&lookInField=bbb&value=[URL][ccc][/ > URL]&returnField=ddd¬Found=eee] > > This will not find the value "&" because the value got url'ed twice, > and the second time encoded the % sign as %25, so the lookup would > unurl once and therefore look for the literal string "%26" instead > of the desired "&". > > Brian Fries > BrainScan Software 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)
that makes sense Brian. Thanks But [ccc] was an incoming formvar, and I did not touch it before looking for its value in the [lookup]. for some unknown reason this was failing: [lookup db=^db/blah.db&lookInField=UserUsername&value=[url][UserID][/ URL]&returnField=UserUsername¬Found=lookupNotfound] yet, this works (I am using this workaround)- [Search db=^db/blah.db&eqUserUsernamedatarq=[url][UserID][/URL]] My guess is that the difference is in the way [url] was working (or not) in the [lookup] compared to the [search]. See the other (long) threads I started over the weekend. (This code is included from a wysiwyg syntax page.) -John On Aug 17, 2009, at 9:59 AM, Brian Fries wrote: > John, > > I url the values in lookups all the time. > > The behavior you see could be explained if [ccc] already contains a > url'ed value. For example: > > [text]ccc=[url]&[/url][/text] > [lookup db=^db/aaa.db&lookInField=bbb&value=[url][ccc][/ > URL]&returnField=ddd¬Found=eee] > > This will not find the value "&" because the value got url'ed twice, > and the second time encoded the % sign as %25, so the lookup would > unurl once and therefore look for the literal string "%26" instead > of the desired "&". > > Brian Fries > BrainScan Software 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:

Internet Explorer 6 Form problems (2005) Logging purchases (1997) WebCat and WebTV (1997) RE: [WebDNA] Secure Cookies (2020) Country & Ship-to address & other fields ? (1997) Help! WebCat2 bug (1997) New public beta available (1997) Error Log with Linux? (2000) Non-repeating Random Numbers - CORRECTION (2002) sendmail on windows (2002) Re:no [search] with NT (1997) How to show via drop down menu? (2000) Some ThankYou page problems (1997) PCS Emailer's role ? (1997) Re:Message Board (1998) New Web Site Developers Database (1996) Mass Mail (2000) WebCat2b13MacPlugIn - syntax to convert date (1997) Sort Order on a page search (1997) [username][password] not showing up! HELP! (1999)