can we use variables in an order_by clause

[rukmangatharaju]

i am setting an order_by clause of a block at runtime
using the built in set_block_propertyblock_name,order_by,x) here i am using x as a variable which will contain database coloumns of the base table of that block..but it is failing. if i give directly the column name then it is working.My requirement is i know the columns of the order by only in the runtime and based on which records should be fetched.
pls mail me if you know the solution.

 

[sem]

It should work. Check syntax:

set_block_property('block_name',order_by,'x')

instead of

set_block_propertyblock_name,order_by,x)

where block_name is the name of your block and x is the name of column in your table (may differ from item name)

Regards, Dima

 

[rukmangatharaju]

thanks for the reply i will try it out.

Raju