[SOLVED] Working with a parameter that contains qoutes

Focal Point

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

January 26, 2012, 01:37 AM

MrM

[SOLVED] Working with a parameter that contains qoutes

I got a problem using a parameter with quotes see URL mine application can be called with a parameter &DEPCDE=000030 or &DEPCDE=000030','000040

http:///ibi_apps/WFServlet?IBIC_server=EDASERVE&IBIAPP_app=&IBIF_ex=&DEPCDE=000030','000040

This works fine when i use SQL :

SELECT DEPDSC
FROM DEPARTMENT
WHERE DEPCDE IN ( ' &DEPCDE ' )

But now the problem:

I have to give the parameter &DEPCDE filled like (&DEPCDE=000030','000040) back with a drilldown to the same application but the quotes are killing me.
How can i solf this?

TYPE=TITLE,
COLUMN=N1,
FOCEXEC=(DEPCDE='&DEPCDE' SORTDIRECTION='&SORTDIRECTION'),
$

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

January 26, 2012, 05:01 AM

Wep5622

I haven't tried, but I would expect that using

&DEPCDE.QUOTEDSTRING

instead of

'&DEPCDE'

would solve your issue.

That said, you can't call .QUOTEDSTRING on parameters with value FOC_NONE.

WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :

January 26, 2012, 06:22 AM

MrM

Hi,

I have found a solution instead of using &DEPCDE=000030','000040 i use &DEPCDE=*000030*,*000040* and with CTRAN i convert the asterisk to a apostrophe.