Render_sql & Order by

Suite and Optimus Suite 5
#1

hello,
I’am using DHTMLX with coldfusion and Mysql.
i have made a grid, with render_sql :

SELECT id, ordre
	FROM table
	WHERE ...

And it works pretty good !

but now, i want to sort my datas in order, by adding

ORDER by ordre

to my query, and it returns me an error :s

i dont want a sortable grid, I just need my rows in the right order…
Do you have an idea ?

#2

Ok I found !
simply add “ASC” or “DESC” to my order instruction and it works \0/

what a noooob !