This still isn't right. Slashes in URL's mean something. You really need to use a function made for this purpose and not re-invent the wheel.
Matt
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of lgoodbar@xxxxxxxxxxxxxx
Sent: Wednesday, April 22, 2009 1:28 PM
To: web400@xxxxxxxxxxxx
Subject: Re: [WEB400] ND Macro screen elimination
Sorry, I had my functions confused. Try replace instead. Note that the
order of search and replace expressions are swapped.
select czfktx,
replace(trim(czfktx),' ','%20') as uriname,
replace(trim(czfktx),' ',' ') as readname
from vngdbdta/dbczrep where czekcd='CODE-813'
Item Description
BRASS 1/4
URINAME
BRASS%201/4
READNAME
BRASS 1/4
--Loyd
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Don Cavaiani
Sent: Wednesday, April 22, 2009 12:05 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] ND Macro screen elimination
I'm getting the following to work, with the exception that there are "&"
shown in place of the blanks. The .pdf is N/F without the '-', and if
I use the '-' for the displayed name, it still wraps. SO CLOSE!!
select translate(trim(SEARCH),'%20','-') as URLNAME,
translate(trim(SEARCH),' ',' ') as ...
Badger&Rubber&Company&10450&&52499.pdf
Bonde'&Quik&Mart&40487&29814.pdf
LTI&Flexible&Products&13070&0038727IN.pdf
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of lgoodbar@xxxxxxxxxxxxxx
Sent: Wednesday, April 22, 2009 10:37 AM
To: web400@xxxxxxxxxxxx
Subject: Re: [WEB400] ND Macro screen elimination
OK, I'm not familiar with Net.Data. Are you performing a SQL query? You
can pull the search name twice: once for the %20 replacement, and again
for the .
Untested SQL: select translate(trim(myname),'%20',' ') as uriname,
translate(trim(myname),' ',' ') as readablename ...
I know it's bad form to integrate style and content, but if this a
purpose-built page intended for web browser consumption, it should be
ok.
Thanks,
Loyd
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Don Cavaiani
Sent: Wednesday, April 22, 2009 9:57 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] ND Macro screen elimination
I am using a variable?
<a href="J:\$(V_SEARCH)">$(V_SEARCH)</a>
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of lgoodbar@xxxxxxxxxxxxxx
Sent: Wednesday, April 22, 2009 9:46 AM
To: web400@xxxxxxxxxxxx
Subject: Re: [WEB400] ND Macro screen elimination
Convert spaces " " to "%20" (no quotes) in the <a href>. %20 is the URI
equivalent for space. If the visible name of the link is breaking across
lines, that can be solved by replacing spaces with " " non-breaking
space.
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
As an Amazon Associate we earn from qualifying purchases.