onmouseover displayed comments [message #549130] |
Wed, 28 March 2012 04:46  |
 |
balckbandit5
Messages: 104 Registered: December 2011
|
Senior Member |
|
|
Hello 
The following is an extract of a report query:
decode((select pmr.IS_APPROVED
from PMO_MILESTONE_REVIEW pmr
where pmr.MILESTONE_ID = pm.MILESTONE_ID
and pmr.ROLE_ID = 1),
1, '<div id="yes" onmouseover="toolTip_enable(event,this,'''||(select pmr.comments
from PMO_MILESTONE_REVIEW pmr
where pmr.MILESTONE_ID = pm.MILESTONE_ID
and PMR.ROLE_ID = 1)||''')"> </div>'
The problem, is that when the comment contains an apostrophe it doesn't work...
Is there a way to work around this?
thanks
[Updated on: Wed, 28 March 2012 04:47] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|