Parameters as Column Name on query

[2004 IR Help]

By: Bruno R. Lima - iceboyy

Parameters as Column Name on query

2004-03-10 13:13

Is it possible to create a parameter with the column names you whant to retrieve, and put it into the query ?

Like:

Param: PARAM_COLS

Query: Select $P{PARAM_COLS} from table

 

 

Is it possible to do it ?

I tryied to do, and put the parameter as String, but it creates Varchar values on my query.

 

Thaks

Bruno

 

 

 

 

By: Giulio Toffoli - gt78

RE: Parameters as Column Name on query

2004-03-10 14:37

 

Yes, you must use a different syntax:

 

instead $P{MyParameter} use

$P!{MyParameter}

 

Please note the ! character.

 

Giulio

[javaiiispl]

 Thanks it work fine..

 

 

 

 

Regards

Javaiiispl.