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. ThanksBut [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.)-JohnOn 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:
that makes sense Brian. ThanksBut [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.)-JohnOn 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)