tag:blogger.com,1999:blog-7631414.post5252966396500434347..comments2023-05-31T04:00:19.993+00:00Comments on Tony Andrews on Oracle and Databases: Conditional column linking in APEXTony Andrewshttp://www.blogger.com/profile/16750945985361011515noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-7631414.post-91653964764015694822019-04-24T10:33:15.143+00:002019-04-24T10:33:15.143+00:00Thanks, this has been very helpful. I was using th...Thanks, this has been very helpful. I was using the url option but have changed to this one. Do not understand the concern about memory. <br />Thanks for sharing. <br />Gerald <br />In Daventry Anonymoushttps://www.blogger.com/profile/12460578012484722408noreply@blogger.comtag:blogger.com,1999:blog-7631414.post-83380474823011289182018-09-18T20:58:54.047+00:002018-09-18T20:58:54.047+00:00HI! I am relatively new to APEX. I am using APEX 1...HI! I am relatively new to APEX. I am using APEX 18 version and my question is --IN region I have link column on clicking it may redirect to page base on condition. For this, we are using branching. But now on clicking, I am not able to open modal page. It just redirects to the page. I want to open a modal or Popup.Shitalhttps://www.blogger.com/profile/16728999888222355078noreply@blogger.comtag:blogger.com,1999:blog-7631414.post-68927703184780161782017-06-30T15:42:04.884+00:002017-06-30T15:42:04.884+00:00@dragy Sorry I only just saw your comment. It loo...@dragy Sorry I only just saw your comment. It looks like you are implementing my old code rather than my new code? If so the problem is likely to be that you have Escape HTML on for that column, it needs to be off.Tony Andrewshttps://www.blogger.com/profile/16750945985361011515noreply@blogger.comtag:blogger.com,1999:blog-7631414.post-88995468446332913022017-03-07T13:52:21.247+00:002017-03-07T13:52:21.247+00:00Hi Tony,
I am missing something, when I do this wa...Hi Tony,<br />I am missing something, when I do this way, get the cell value of , '<a href="f?...', not value from database. Can you tel me please where I am going wrong?Anonymoushttps://www.blogger.com/profile/12901221434770712466noreply@blogger.comtag:blogger.com,1999:blog-7631414.post-69390068576448449672016-07-22T13:30:29.787+00:002016-07-22T13:30:29.787+00:00Scott, I agree about the link being reenableable (...Scott, I agree about the link being reenableable (that's a word now!) and mentioned other ways users could circumvent this. In my particular scenario, security is not a concern (I don't mid the user clicking the link, there is just no point for them in doing so). <br />Also agree I shouldn't have used &SESSION. But I'm not sure about your deterministic function point though:Tony Andrewshttps://www.blogger.com/profile/16750945985361011515noreply@blogger.comtag:blogger.com,1999:blog-7631414.post-40320993543914655782016-07-22T13:05:58.495+00:002016-07-22T13:05:58.495+00:00I think you've replaced a security risk that c...I think you've replaced a security risk that can be mitigated with apex_escape.html with a link that could be reenabled with a few clicks in browser tools.<br />Your concern on performance with a probably deterministic function call is outweighed by using substitution strings to populate session id. This will flood your shared pool.Scott Wesleyhttps://www.blogger.com/profile/18106937181788036683noreply@blogger.com