How to pass string parameter without quotes?

[VORiAND]

Hi!

I have a very simple query in my report which has an ORDER BY at the end with one parameter:

ORDER BY  $P{form_item_order}[/code]

My problem is very simple. The ORDER BY is not wokring. The query looks like this:

product_data.`NAME` AS PRODUCT_NAME,product_data.`ITEM_NR` AS ITEM_NR,product_data.`EAN` AS EAN,[/code]

... if I give the parameter in, in the preview and if I execute it in my app, it's not working, because it's a string and it gets quotes. If I enter my query in MySQLWorkbench end execute it without any quote like this: ORDER BY PRODUCT_NAME it's working... I don't know why. But it looks like I need to pass a string without quotes. Is it possible?

[hozawa]

Use

ORDER BY  $P!{form_item_order}