Re: & in Lookups

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 15731
interpreted = N
texte = This may be a bug in 2.01. It's being tested and if it's a problem, will be fixed in 2.1. In the mean time, you can always use [search] instead of [lookup] and do a [showif [numfound]=0] for the notFound message. This isn't as compact, but should give the desired results. Thanks.John>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.>>Michael>>Michael 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/ John A. Hill, V.P. Marketing Pacific Coast SoftwareeCommerce / Web Developer Tools http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

This may be a bug in 2.01. It's being tested and if it's a problem, will be fixed in 2.1. In the mean time, you can always use [search] instead of [lookup] and do a [showif [numfound]=0] for the notFound message. This isn't as compact, but should give the desired results. Thanks.John>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.>>Michael>>Michael 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/ John A. Hill, V.P. Marketing Pacific Coast SoftwareeCommerce / Web Developer Tools http://www.smithmicro.com John Hill

DOWNLOAD WEBDNA NOW!

Re: & in Lookups

1997

Top Articles:

Related Readings: