Re: datagrid not doing limit query upon dataobject

daniel@electroteque.org wrote:

By "custom query" do you mean you're calling find(). If you're using the DataObject DataSource you should *not* be calling find() on the object. The DataSource should be doing that,

Custom query as in i hacked the find method to send a custom query which returns selected fieldswith normal join syntax, because joinAdd is tedious and hasnt been working. Because if i did a_query(sql); find would also send another query. Actually, the DO datasource will first check to see if you have submitted a query. If you have run query(), then it will not run find().

The only problem with this, is you will have to load all of the records into the datagrid as well as handle sorting yourself. Andrew