(and =for the list archives, please note/remember this code is being called =from a wysiwyg-syntax page, linux, webdna =6.1
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=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¬Found=3DNamasteNahinHaiBhai-1][/text]
[text show=3DF]thisIs4Donovan2=3D[lookup =db=3D^db/some.db&lookInField=3DUserUsername&value=3D[URL][UserID][=/URL]&returnField=3DUserUsername¬Found=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:
--Apple-Mail-2--494205128Content-Type: text/plain;charset=US-ASCII;format=flowed;delsp=yesContent-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.1this 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--494205128Content-Type: text/html;charset=US-ASCIIContent-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¬Found=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,=div>
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