Re: ND Macro screen elimination

@DTW_URLESCSEQ(stringIn, stringOut)
@DTW_rURLESCSEQ(stringIn)

Thanks,
Todd Allen




"Haas, Matt (CL
Tech Sv)"
<matt.haas@cengag To
e.com> Web Enabling the AS400 / iSeries
Sent by: <web400@xxxxxxxxxxxx>
web400-bounces@mi cc
drange.com
Subject
Re: [WEB400] ND Macro screen
2009-04-22 13:35 elimination


Please respond to
Web Enabling the
AS400 / iSeries
<web400@midrange.
com>






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),' ','&nbsp;') as readname
from vngdbdta/dbczrep where czekcd='CODE-813'

Item Description
BRASS 1/4

URINAME
BRASS%201/4

READNAME
BRASS&nbsp;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),'&nbsp;',' ') 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 &nbsp;.

Untested SQL: select translate(trim(myname),'%20',' ') as uriname,
translate(trim(myname),'&nbsp;',' ') 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 "&nbsp;" non-breaking
space.




This communication and any transmitted documents are intended to be confidential. If there is a problem with this transmission, please contact the sender. If the reader of this message is not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.