Just another Perl shrine | |
PerlMonks |
Re: RFC : AJAX + DBI = DBIx::LiveGridby mje (Curate) |
on Sep 16, 2005 at 13:43 UTC ( [id://492608]=note: print w/replies, xml ) | Need Help?? |
Thanks for this. I had a few problems using DBD::ODBC and MS SQL Server. With a table of 1000 rows: What I found is the data grid displayed the first 70 rows repeatedly as you scrolled. I tracked this down to the SQL being run and then found SQL::Abstract::Limit says $order must be specified when $rows is specified. DBIx::LiveGrid only sets $order if you click on a column heading. I verified this with SQL::Abstract::Limit which produces the following incorrect SQL when $order is not specified: and the following correct SQL when $order is specified:
I did a rough change to DBIx::LiveGrid to work around this: and then changed livegrid.cgi:
I hope this helps. BTW, I think there is a bug in IE 6.0.2800.1106 which means the row data is not updated every time when scrolling past the rowset points (70).
In Section
Meditations
|
|