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 converts them to © and ® and then chokes on the ampersand.Putting in the higher ASCII © works, but ® displays as a line (¨). The only way to get the ® symbol is to say ®.It's like the LOOKUP tage is expecting another argument after the & so it ignore whatever comes next.MichaelMichael Winston *By Phone!: (503)/652/8815 x341 Internet Coordinator *By e-mail!: michaelw@dhorse.com Dark 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 converts them to © and ® and then chokes on the ampersand.Putting in the higher ASCII © works, but ® displays as a line (¨). The only way to get the ® symbol is to say ®.It's like the LOOKUP tage is expecting another argument after the & so it ignore whatever comes next.MichaelMichael Winston *By Phone!: (503)/652/8815 x341 Internet Coordinator *By e-mail!: michaelw@dhorse.com Dark 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)