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 = 103285
interpreted = N
texte = --Apple-Mail-2--494205128 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit > John Butler wrote: >> 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]] > [snip] > > does this work? > [Search db=^db/blah.db&eqUserUsernamedatarq=[URL][UserID][/ > URL]&UserUsernamecase=T] Donovan, These are exact cut and pastes: (and for the list archives, please note/remember this code is being called from a wysiwyg-syntax page, linux, webdna 6.1 this code: = = = = = = ======================================================================== [!]------------------------ START input UserID must be unique ------------------------------[/!] [!]------------------------ search1------------------------------[/!] [Search db=^db/some.db&eqUserUsernamedatarq=[URL][UserID][/URL]] [showif [URL][numfound][/URL]>0] [text show=F]AlertUser2Neglect=[AlertUser2Neglect]* Sorry, but the 'User ID' you entered is already taken; please choose another one.
[unurl]%0D%0A[/unurl][/text] [/showif] [/Search] [!]---This is for Donovan (&FIELDNAMEcase=T)---[/!] [!]------------------------ search2------------------------------[/!] [Search db=^db/some.db&eqUserUsernamedatarq=[URL][UserID][/URL]] [showif [URL][numfound][/URL]>0] [text show=F]AlertUser2Neglect=[AlertUser2Neglect]* Sorry, but the 'User ID' you entered is already taken; please choose another one.
[unurl]%0D%0A[/unurl][/text] [/showif] [/Search] [!]------------------------ search3------------------------------[/!] [Search db=^db/some.db&eqUserUsernamedatarq=[URL][UserID][/ URL]&UserUsernamecase=T] [showif [URL][numfound][/URL]>0] [text show=F]AlertUser2Neglect=[AlertUser2Neglect]* Sorry, but the 'User ID' you entered is already taken; please choose another one.
[unurl]%0D%0A[/unurl][/text] [/showif] [/Search] [text show=F]thisIs4Donovan1=[lookup db=^db/ some .db &lookInField = UserUsername &value =[UserID]&returnField=UserUsername¬Found=NamasteNahinHaiBhai-1][/ text] [text show=F]thisIs4Donovan2=[lookup db=^db/ some.db&lookInField=UserUsername&value=[URL][UserID][/ URL]&returnField=UserUsername¬Found=NamasteNahinHaiBhai-2][/text] = = = = = = ======================================================================== returns this: As far as I have spent brain juice on this, I swear the issue is the [url]-inside-certain-webdnaTags-in-code-called-from-wysiwyg-syntax- pages bug. -- Happy Monday! :-) really! --Apple-Mail-2--494205128 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable
John Butler wrote:
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=3D^db/blah.db&lookInField=3DUserUsername&value=3D[URL][UserID][= /URL]&returnField=3DUserUsername&notFound=3DlookupNotfound] yet, =  this works (I am using this = workaround)-
[Search = db=3D^db/blah.db&eqUserUsernamedatarq=3D[URL][UserID][/URL]]
[snip]

does this work?
[Search = db=3D^db/blah.db&eqUserUsernamedatarq=3D[URL][UserID][/URL]&UserUs= ernamecase=3DT]

Donovan,

These are exact cut and pastes:
(and = for the list archives, please note/remember this code is being called = from a wysiwyg-syntax page, linux, webdna = 6.1

this = code:
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D
[!]------------------------ = START input UserID must be unique = ------------------------------[/!]

<!-- = Version=3D[Version],PLATFORM=3D[PLATFORM], = -->

[!]------------------------ = search1------------------------------[/!]
[Search = db=3D^db/some.db&eqUserUsernamedatarq=3D[URL][UserID][/URL]]
<!-- search found =3D [numfound]-->
[showif = [URL][numfound][/URL]>0]
[text = show=3DF]AlertUser2Neglect=3D[AlertUser2Neglect]* Sorry, but the 'User = ID' you entered is already taken; please choose another one.<br = />[unurl]%0D%0A[/unurl][/text]
= [/showif]
[/Search]

[!]---This = is for Donovan = (&FIELDNAMEcase=3DT)---[/!]

[!]--------------= ---------- search2------------------------------[/!]
[Search = db=3D^db/some.db&eqUserUsernamedatarq=3D[URL][UserID][/URL]]
<!-- search2 found =3D [numfound]-->
[showif = [URL][numfound][/URL]>0]
[text = show=3DF]AlertUser2Neglect=3D[AlertUser2Neglect]* Sorry, but the 'User = ID' you entered is already taken; please choose another one.<br = />[unurl]%0D%0A[/unurl][/text]
= [/showif]
[/Search]

[!]---------= --------------- = search3------------------------------[/!]
[Search = db=3D^db/some.db&eqUserUsernamedatarq=3D[URL][UserID][/URL]&UserUs= ernamecase=3DT]
<!-- search3 found =3D = [numfound]-->
[showif = [URL][numfound][/URL]>0]
[text = show=3DF]AlertUser2Neglect=3D[AlertUser2Neglect]* Sorry, but the 'User = ID' you entered is already taken; please choose another one.<br = />[unurl]%0D%0A[/unurl][/text]
= [/showif]
[/Search]

[text = show=3DF]thisIs4Donovan1=3D[lookup = db=3D^db/some.db&lookInField=3DUserUsername&value=3D[UserID]&r= eturnField=3DUserUsername&notFound=3DNamasteNahinHaiBhai-1][/text]
[text show=3DF]thisIs4Donovan2=3D[lookup = db=3D^db/some.db&lookInField=3DUserUsername&value=3D[URL][UserID][= /URL]&returnField=3DUserUsername&notFound=3DNamasteNahinHaiBhai-2]= [/text]
<!-- thisIs4Donovan1 =3D = [thisIs4Donovan1]-->
<!-- thisIs4Donovan2 =3D = [thisIs4Donovan2]-->
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

= returns this:
<!-- Version=3D6.1,PLATFORM=3Dunix-Linux Intel RedHat, =-->
<!-- search =found =3D 1-->
<!-- search2 = found =3D 1-->
<!-- search3 found =3D = 1-->
<!-- thisIs4Donovan1 =3D = JohnTest_aug17-->
<!-- thisIs4Donovan2 =3D = NamasteNahinHaiBhai-2-->

As far as I have = spent brain juice on this, I swear the issue is the = [url]-inside-certain-webdnaTags-in-code-called-from-wysiwyg-syntax-pages = bug.
--
Happy = Monday!
:-)
really!

= --Apple-Mail-2--494205128-- 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)
--Apple-Mail-2--494205128 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit > John Butler wrote: >> 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]] > [snip] > > does this work? > [Search db=^db/blah.db&eqUserUsernamedatarq=[url][UserID][/ > URL]&UserUsernamecase=T] Donovan, These are exact cut and pastes: (and for the list archives, please note/remember this code is being called from a wysiwyg-syntax page, linux, webdna 6.1 this code: = = = = = = ======================================================================== [!]------------------------ START input UserID must be unique ------------------------------[/!] [!]------------------------ search1------------------------------[/!] [Search db=^db/some.db&eqUserUsernamedatarq=[url][UserID][/URL]] [showif [url][numfound][/URL]>0] [text show=F]AlertUser2Neglect=[AlertUser2Neglect]* Sorry, but the 'User ID' you entered is already taken; please choose another one.
[unurl]%0D%0A[/unurl][/text] [/showif] [/Search] [!]---This is for Donovan (&FIELDNAMEcase=T)---[/!] [!]------------------------ search2------------------------------[/!] [Search db=^db/some.db&eqUserUsernamedatarq=[url][UserID][/URL]] [showif [url][numfound][/URL]>0] [text show=F]AlertUser2Neglect=[AlertUser2Neglect]* Sorry, but the 'User ID' you entered is already taken; please choose another one.
[unurl]%0D%0A[/unurl][/text] [/showif] [/Search] [!]------------------------ search3------------------------------[/!] [Search db=^db/some.db&eqUserUsernamedatarq=[url][UserID][/ URL]&UserUsernamecase=T] [showif [url][numfound][/URL]>0] [text show=F]AlertUser2Neglect=[AlertUser2Neglect]* Sorry, but the 'User ID' you entered is already taken; please choose another one.
[unurl]%0D%0A[/unurl][/text] [/showif] [/Search] [text show=F]thisIs4Donovan1=[lookup db=^db/ some .db &lookInField = UserUsername &value =[UserID]&returnField=UserUsername¬Found=NamasteNahinHaiBhai-1][/ text] [text show=F]thisIs4Donovan2=[lookup db=^db/ some.db&lookInField=UserUsername&value=[url][UserID][/ URL]&returnField=UserUsername¬Found=NamasteNahinHaiBhai-2][/text] = = = = = = ======================================================================== returns this: As far as I have spent brain juice on this, I swear the issue is the [url]-inside-certain-webdnaTags-in-code-called-from-wysiwyg-syntax- pages bug. -- Happy Monday! :-) really! --Apple-Mail-2--494205128 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable
John Butler wrote:
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=3D^db/blah.db&lookInField=3DUserUsername&value=3D[url][UserID][= /URL]&returnField=3DUserUsername&notFound=3DlookupNotfound] yet, =  this works (I am using this = workaround)-
[Search = db=3D^db/blah.db&eqUserUsernamedatarq=3D[url][UserID][/URL]]
[snip]

does this work?
[Search = db=3D^db/blah.db&eqUserUsernamedatarq=3D[url][UserID][/URL]&UserUs= ernamecase=3DT]

Donovan,

These are exact cut and pastes:
(and = for the list archives, please note/remember this code is being called = from a wysiwyg-syntax page, linux, webdna = 6.1

this = code:
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D
[!]------------------------ = START input UserID must be unique = ------------------------------[/!]

<!-- = Version=3D[version],PLATFORM=3D[platform], = -->

[!]------------------------ = search1------------------------------[/!]
[Search = db=3D^db/some.db&eqUserUsernamedatarq=3D[url][UserID][/URL]]
<!-- search found =3D [numfound]-->
[showif = [url][numfound][/URL]>0]
[text = show=3DF]AlertUser2Neglect=3D[AlertUser2Neglect]* Sorry, but the 'User = ID' you entered is already taken; please choose another one.<br = />[unurl]%0D%0A[/unurl][/text]
= [/showif]
[/Search]

[!]---This = is for Donovan = (&FIELDNAMEcase=3DT)---[/!]

[!]--------------= ---------- search2------------------------------[/!]
[Search = db=3D^db/some.db&eqUserUsernamedatarq=3D[url][UserID][/URL]]
<!-- search2 found =3D [numfound]-->
[showif = [url][numfound][/URL]>0]
[text = show=3DF]AlertUser2Neglect=3D[AlertUser2Neglect]* Sorry, but the 'User = ID' you entered is already taken; please choose another one.<br = />[unurl]%0D%0A[/unurl][/text]
= [/showif]
[/Search]

[!]---------= --------------- = search3------------------------------[/!]
[Search = db=3D^db/some.db&eqUserUsernamedatarq=3D[url][UserID][/URL]&UserUs= ernamecase=3DT]
<!-- search3 found =3D = [numfound]-->
[showif = [url][numfound][/URL]>0]
[text = show=3DF]AlertUser2Neglect=3D[AlertUser2Neglect]* Sorry, but the 'User = ID' you entered is already taken; please choose another one.<br = />[unurl]%0D%0A[/unurl][/text]
= [/showif]
[/Search]

[text = show=3DF]thisIs4Donovan1=3D[lookup = db=3D^db/some.db&lookInField=3DUserUsername&value=3D[UserID]&r= eturnField=3DUserUsername&notFound=3DNamasteNahinHaiBhai-1][/text]
[text show=3DF]thisIs4Donovan2=3D[lookup = db=3D^db/some.db&lookInField=3DUserUsername&value=3D[url][UserID][= /URL]&returnField=3DUserUsername&notFound=3DNamasteNahinHaiBhai-2]= [/text]
<!-- thisIs4Donovan1 =3D = [thisIs4Donovan1]-->
<!-- thisIs4Donovan2 =3D = [thisIs4Donovan2]-->
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

= returns this:
<!-- Version=3D6.1,PLATFORM=3Dunix-Linux Intel RedHat, =-->
<!-- search =found =3D 1-->
<!-- search2 = found =3D 1-->
<!-- search3 found =3D = 1-->
<!-- thisIs4Donovan1 =3D = JohnTest_aug17-->
<!-- thisIs4Donovan2 =3D = NamasteNahinHaiBhai-2-->

As far as I have = spent brain juice on this, I swear the issue is the = [url]-inside-certain-webdnaTags-in-code-called-from-wysiwyg-syntax-pages = bug.
--
Happy = Monday!
:-)
really!

= --Apple-Mail-2--494205128-- 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:

Writing custom WebCat searches?? (2000) Configuration Q (1998) In Digest Dijon (2000) Does anyone have a solution to make carts smaller? (1998) Bug Report, maybe (1997) PCS Frames (1997) Testing 123... (2008) UPDATE PROBLEM (1997) DON'T use old cart file! (1997) [WriteFile] problems (1997) Large founditems loops (2000) Meet your competition (2000) WebCat hosting providers? (1997) OT: Site Test (2006) PCS Customer submissions ? (1997) last word listed (2000) Sort Order on a page search (1997) MultiGroupChecker (2000) wierd crashes for multi-sendmails on NT (1997) [WebDNA] Need to get off! (2008)