@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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.