Re: & in Lookups
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 15730
interpreted = N
texte = At 9:16 AM -0800 12/18/97, John Hill is rumored to have typed:> >> [LOOKUP> >>>db=legal.db&value=[sku]&lookinfield=SKU&ReturnField=Legal&NotFound=[URL]Some> >>> legal text including © and ®[/URL]]> >> >I get :> >Some%20legal%20text%20....> >Not quite what I need.> >>> The %20's are converted back to space chars by WebCatalog. What you've>shown above looks correct. However, if you are actually looking for the>copyright character (©) then you should put that in the text and it will>be URLized. If the HTML equivalent (©) is in your text then leave it>the way you have it.The %20s are not converted back, or else I wouldn't see them on my web page.I've tried just about every permutation of the advice given. [URL][/URL]keeps the %20s. Putting © in the string truncates the string.Putting © and ® with [CONVERTCHARS] doesn't work because Webcat convertsthem to © and ® and then chokes on the ampersand.Putting in the higher ASCII © works, but ® displays as a line (¨). Theonly way to get the ® symbol is to say ®.It's like the LOOKUP tage is expecting another argument after the & so itignore whatever comes next.MichaelMichael Winston *By Phone!: (503)/652/8815 x341Internet Coordinator *By e-mail!: michaelw@dhorse.comDark Horse Comics, Inc. *By web!: http://www.dhorse.com/
Associated Messages, from the most recent to the oldest:
At 9:16 AM -0800 12/18/97, John Hill is rumored to have typed:> >> [LOOKUP> >>>db=legal.db&value=[sku]&lookinfield=SKU&ReturnField=Legal&NotFound=
[url]Some> >>> legal text including © and ®[/URL]]> >> >I get :> >Some%20legal%20text%20....> >Not quite what I need.> >>> The %20's are converted back to space chars by WebCatalog. What you've>shown above looks correct. However, if you are actually looking for the>copyright character (©) then you should put that in the text and it will>be URLized. If the HTML equivalent (©) is in your text then leave it>the way you have it.The %20s are not converted back, or else I wouldn't see them on my web page.I've tried just about every permutation of the advice given.
[url][/URL]keeps the %20s. Putting © in the string truncates the string.Putting © and ® with
[convertchars] doesn't work because Webcat convertsthem to © and ® and then chokes on the ampersand.Putting in the higher ASCII © works, but ® displays as a line (¨). Theonly way to get the ® symbol is to say ®.It's like the LOOKUP tage is expecting another argument after the & so itignore whatever comes next.MichaelMichael Winston *By Phone!: (503)/652/8815 x341Internet Coordinator *By e-mail!: michaelw@dhorse.comDark Horse Comics, Inc. *By web!: http://www.dhorse.com/
Michael Winston
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:
Pithy questions on webcommerce & siteedit (1997)
Attn: Bug in GeneralStore example b15 (1997)
[WebDNA] Competitors! (2008)
Bug or syntax error on my part? (1997)
[WebDNA] Bullet proof dynamic tables (2009)
ASCII Code 127 (2004)
Date search bug (1998)
TCPconnect to DNS (2000)
Virtual hosting and webcatNT (1997)
Checkboxes (1998)
2 databases (1998)
WebCat2b15MacPlugin - showing [math] (1997)
Re(5): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998)
FS WebCatalaog license (2000)
Country & Ship-to address & other fields ? (1997)
PDF Writefile problem (2005)
WebTen Type 2 Crash on start (2000)
Sendmail (1999)
UPS (2003)
Pre-parse hell (2008)