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:

WebCat2 - many [carts] on one template page? (1997) WebDNA Examples - Call for submission... (1998) [movefile] (1999) WebCat2b12plugin - [search] is broken ... not! (1997) Rumpus/Typhoon modules included in Typhoon ... (1997) process SSI (1998) reservation program (2000) Server capacity (2003) ShowNext example for GeneralStore (1997) Cookie Crumble (1998) What if SSL server down? MAC (1997) WebCat editing, SiteGuard & SiteEdit (1997) Upgrading old WebCat Database Files (1997) Web Catalog 2 demo (1997) Single Link browsing (1997) BBEdit WedDNA Codeless Language Module (2004) PC Cookie Problem? (2003) PIXO support (1997) [shell]? (2000) WebMerchant Error (1998)