Start Building Professional
Web Apps Today

Connector ORDER BY in render_sql

Hi,

This is my question:

i create a grid with connector and render_sql command....
the grid have :

attachHeader("#connector_text_filter"); and        
setColSorting("connector")

In render_sql there is a select with wher clause and order by clause...

all works but when i filter the grid it gives me an error in sql command because it is added another where clause after all and obiviously its not a correct commands...

is there a way to adjust this?

thank u