Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Passing a comma in a parameter within a URL

570089Sep 13 2007 — edited Oct 24 2007

I am trying to pass a parameter whose value contains a comma into Discoverer Viewer using a URL. I have followed the instructions that are given in the Disco documentation, substituting ~44 into the URL where the comma appears. Here's how it looks:

http://elvis.rock.local:7777/discoverer/viewer?us=anyuser&db=prod&eul=prodeul&wbk=ACT001TESTURL&wsk=2234&qp_Drivers=Smith~44+Shad+A+/+ssmith,Brady~44+Tom++/+brady&qp_Company=Mycompany

The problem is that the parameter values show up as 'Smith~44 Shad A / ssmith','Brady~44 Tom / brady' rather than what I expected: 'Smith, Shad A / ssmith','Brady, Tom / brady'. I have tried using ~32 and 002c instead, also tried enclosing in quotation marks, i.e., '~44'.

Obviously I don't get any results because the values passed in the parameters don't match up with the values in my table.

Any suggestions?
Thanks in advance,
Tricia

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 21 2007

Added on Sep 13 2007

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

6 comments

1,690 views