Re: ND Macro screen elimination -- WEB400

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.