Focal Point
[Solved] Escaping html specific signs

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6307028906

September 16, 2011, 06:45 AM
MichaelBalle
[Solved] Escaping html specific signs
In our application we have very complex conditions. In the first case we work on a FOC table, in the second we read a sql table. To minimize the amount of maintenance and to have a single point of failure the conditions are held in a table also in WebFOCUS format (e.g. " DEALER_COST LE 10000").
Now we tried to transfer this condition to SQL notation ("DEALER_COST <= 10000").
Using STRREP we got the result "DEALER_COST <= 10000").
Any suggestion? The documentation only deals with escaping in the WHERE statement.

Thanks in advance and have a nice weekend

This message has been edited. Last edited by: MichaelBalle,


WebFOCUS 7.6, 7.7
Windows, All Output formats
September 16, 2011, 10:37 AM
njsden
I don't seem to understand what your issue/need is.

Using STRREP eems to be getting what SQL expects in terms of a filtering expression -- I am assuming you're reading that into a amper variable and later adding it to your SQL statement.

Why do you need to escape the characters? Are you somehow reading this to populate an HTMl launch screen and then pass those values back to a WebFOCUS procedure to be used?

Could you please elaborate a bit more as to what you're doing and what exactly is not working. Some code sample (using the CAR table) would be helpful.

Thanks!



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.