Re: datagrid not doing limit query upon dataobject

On Wed, 26 Jan 2005 10:49:33 +1100 (EST), daniel@electroteque.org <daniel@electroteque.org> wrote: > > On Wed, 26 Jan 2005 09:34:54 +1100, electroteque > > <daniel@electroteque.org> wrote: > >> it seems thet datagrid isnt doing a limit query upon dataobject and > >> just returning all the data into an array which is then limited, any > >> ideas how to put this in ? I have finally hacked dataobject to do my > >> own custom query against find(). > >> > > > > Are you using the newest (CVS) version of DataGrid? > > umm possibly ? > > > Are you binding the > > DO itself? > > > i bind the d0 but do a custom query first. 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, > > Are you calling find() on the DO (don't do this)? > > umm i think i am ? > > What DB > > backend are you using? > > mdb2 , with modified datasource for mdb2 > Ok. What is the actual database backend, though. mysql? oracle? If not mysql, does MDB / MDB_DO support limit queries on that database? And seeing as this is with MDB_DO (which is not official) are you sure limit() works correctly on it? -- Justin Patrin