How to pass column name as parameter in sql query.

In my scenario I need to pass column name from mashup and want to display only that column data in grid.

PS : I have created a database thing which has a service that takes input as column name and fetch that column data .

When I pass parameter as shown in the image its returning the parameter name in place of data of the column.

Can anyone help how to pass column name from input parameter.

5-Regular Member

Hello, Sudipta Jatta.

I found the article below which implies this is not a supported function of SQL Query.

Unless I am misunderstanding your use case.

-- Craig A.

5-Regular Member

sudipta jatta: Please replace [] with << >> to make query as below :

select <<EmployeeName>> from advancedanamoly_sh2;

Please be careful with the usage in query since it might opens up security risk with SQL injections at run time.

-Durgesh

Sign up