SQL Developer

Xandot wrote:

Facing issue while redirecting text values from one page to another like:

Page 1:

Page 2:

when I like to empno then it'll transfer ename to the next page on ename field but problem is its only showing "J & a".

after comma text is not copied to the next page, so how to handle this kind on the issue related to special char?

I'm using below code URL code for redirect page:

HTML Header:

1. <scriptlanguage="JavaScript"type="text/javascript">
2. functioncallMyPopup(ENAME,EMPNO){
3. varurl;
4. url='f?p=&APP_ID.:11:&APP_SESSION.::::P11_ENAME,P11_EMPNO:'+escape(ENAME)+','+EMPNO;
5. w=open(url,"winLov","Scrollbars=1,resizable=1,width=925,height=400");
6. }
7. </script>

<script language="JavaScript" type="text/javascript"> function callMyPopup (ENAME,EMPNO) { var url; url = 'f?p=&APP_ID.:11:&APP_SESSION.::::P11_ENAME,P11_EMPNO:'+ escape(ENAME) +',' + EMPNO; w = open(url,"winLov","Scrollbars=1,resizable=1,width=925,height=400"); } </script>

It's possible to pass values containing commas in APEX URLs by escaping the value using backslashes ("\") as described in the documentation:

f?p=&APP_ID.:11:&APP_SESSION.::::P11_ENAME,P11_EMPNO:\'+escape(ENAME)+'\,'+EMPNO

However, generally the best approach is simply not to pass string values in URLs. Whilst it is possible to escape strings to make them URL- and APEX parameter-safe, it is much better practice to avoid the problem altogether. Change the application so that it only passes alphanumeric EMPNO key values as URL parameters. In target pages/regions, use the key value to retrieve ENAME using region/item source attributes, computations, or processes.