We have recently moved our platform from mainframe to win/2000 and in the process of upgrading from 4.3.6 to 5.2. I have an .asp page which is a chartdirector chart which calls my report (focexec) I pass several parameters from chart to report one of which is the webserver where the .asp was running. I need this webserver name to begin an URL which calls a web page and parses a few parameters. this works fine. However I have a drilldown report which in turns needs this webserver name to begin an URL...same ones actually... I have my code as:

This is the one I need it for and works on the first report.
TYPE=DATA, COLUMN=N5,
URL=&URL/my/web/page.asp? \
(Code='V' Number=NO), $

This is where I am passing it to the drilldown report so I can pass it into the drill down like above code.
TYPE=DATA, COLUMN=N1,
FOCEXEC=myfocexec \
(ID=ID FSRV='WIN' URL='&URL'),$

my problem arises in that focus is turning some of the URL components into hex code. for instance I want this to read http://myserver.fl.state.us
but what I get is http:%3A//myserver%2Estate%2Eus
and this bombs the calling of the drilldown.

any help would be much appreciated.

PS. I even hard coded the URL to read like this:
TYPE=DATA, COLUMN=N1,
FOCEXEC=myfocexec \
(ID=ID FSRV='WIN' URL='http://myserver.fl.state.us'),$
It still passed this: http:%3A//myserver%2Estate%2Eus.

Thanks in Advance

This message has been edited. Last edited by: <Kathryn Henning>,

It's not WebFOCUS that's changing the characters to their offsets, it's your browser. As long as its the browser then reading the URl, there should be no problem. When you look at the URL in the broswer do you see the correct URL?

I have a similar issue where I went from WF 764 to WF 8006 and now the URL’s in all previous report do not work… the ? is being converted to Hex and the thing bombs…. All output is excel 2000.

Therefore I can not promote any report to production…. And in WF 764 this is not a problem therefore it is not the browser is it!

Trying to keep this active
The same report (foc exec) run in 764 can correctly encode the ? and the excel drilldown works without issue
In 8006 the ? is encoded to %3F and the drilldown fails.
If anyone can assist that would be tremendous

What's to prevent you from applying STRREP() to &URL, to reverse the url encoding?

please elaborate as I have this working in 764 but not in 8006

TYPE=DATA,
COLUMN=N9,
JUSTIFY=LEFT,
URL=http://bcpweb.fg.rbc.com/default.htm?(teid=N10 &te=N7),
$

the question mark in the url is transformed to %3F in the excel output in version 8006 in version 764 it works

Oh. I thought you meant your fex was receiving the url as a parameter (&URL), and it arrived with the "?" url-encoded.

Just trying to keep this alive, because in my wf 764 all my URL links with a ? And & work just fine but in wf 8006 then are transformed to %3f and %26 respectfully and the link error is HTTP/1.0 404
I have a case open but hope that this forum might shed light on this issue

Example of the failed link is

https://weather.gc.ca/marine/f...apID=11&siteID=08207 works in 764 but not in 8006