Mirmo Dynamics - Tag - zend_db_table - Comments

Zend Framework Pagination reloaded - apoca

apoca — Thu, 14 Aug 2008 01:01:10 +0200

I try with 1.5 and does not work... If someone have a pagination component working in version 1.5 say something in this blog... :)

Bugfixes release of Zend Framework pagination component - Samer

Samer — Wed, 06 Aug 2008 12:15:15 +0200

Hi, i have problem using the component. I get Zend_Db_Statement_Exception (SQLSTATE42000: Syntax error or access violation:...).

I use this code in my controller:
$albums = new Riskle_Db_Table_Paginate(new Albums, $this->_getParam('page'));
$this->view->albums = $albums->fetchAll(null, 'title DESC');
$this->view->paginationInfos = $albums->getPaginationInfos();

And here is my albums class:
class Albums extends Riskle_Db_Table
{
protected $_name = 'albums';
}

So, could you please tell what is wrong with my code?

Zend Framework Pagination reloaded - idleboy

idleboy — Tue, 22 Jul 2008 07:49:23 +0200

hi ,

this page r supports ZF 1.5 ???

Bugfixes release of Zend Framework pagination component - Geoffrey

Geoffrey — Fri, 11 Apr 2008 11:43:09 +0200

Hi, I just uploaded the revision 122 to my own server:

http://fashion.hosmoz.net/public/pa...

Bugfixes release of Zend Framework pagination component - monk.e.boy

monk.e.boy — Fri, 11 Apr 2008 09:29:07 +0200

The link to the code seems to be down :-(

Any chance you could post it on this server please?

monk.e.boy

Zend Framework Pagination reloaded - Geoffrey

Geoffrey — Mon, 31 Mar 2008 10:09:38 +0200

Hi Paul, there's a new version of this component available at http://fashion.hosmoz.net/post/2007...

Regards,

Geoffrey

Zend Framework Pagination reloaded - Paul

Paul — Mon, 31 Mar 2008 00:23:03 +0200

Hi,

I think your SVN is down. Any chance of posting the code in the blog instead?

Thanks.

Zend_Db_Table and tables relationships - Geoffrey

Geoffrey — Mon, 14 Jan 2008 11:10:42 +0100

Hi Sebas, my repository has moved to assembla (http://www.assembla.com/), I've updated the link to reflect this change. Thanks for your report.

Zend_Db_Table and tables relationships - Sebas

Sebas — Fri, 11 Jan 2008 20:11:23 +0100

You SVN repository is down it's imposible to download the source ...
Could you put a ZIP archive on your website

Zend Framework Pagination, third strike - Geoffrey

Geoffrey — Tue, 01 Jan 2008 14:35:07 +0100

Hi brandon, there's no way atm to set the items per page property, I'm aware of this and this will be fixed in the next release, as well as the html syntax quirk you're pointing.

thanks for your feedback

Zend Framework Pagination, third strike - brandon

brandon — Fri, 28 Dec 2007 18:33:44 +0100

Great job on the pager. One thing that i am not clear on however, is there a way to set the _itemsPerPage property in Riskle_Db_Table_Paginate class?

I noticed also in the view helper that there was a syntax error in the default html. you start with a <p> but end with a </li> for the previous and next functions.

Zend Framework Pagination, third strike - jude

jude — Sun, 16 Dec 2007 22:37:33 +0100

i am a newbie. where do i place the library files?

Zend Framework Pagination, third strike - Erik

Erik — Mon, 24 Sep 2007 14:45:25 +0200

As far as I know the problem stems from a MySQL limitation, not supporting FULL OUTER JOIN. I've seen some hacks that use UNIONs to get the desired result but I'm not sure how well it would translate to the framework and unfortunately don't have the time to investigate right now. If I get some free time and find a better method I'll post it. :-)

Zend Framework Pagination, third strike - Geoffrey

Geoffrey — Mon, 24 Sep 2007 11:18:59 +0200

Once again thanks for the patch :-) While I not found this a very clean way of doing things, it'll do the job for the moment as I can't think (did not take the time to think actually) of another way to fix the problem.

Concerning the _fetch thing, I can't believe I did not think of it earlier. Patching at the lower level seems the way to go.

Zend Framework Pagination, third strike - Rumeurs

Rumeurs — Mon, 24 Sep 2007 09:12:01 +0200

tu composes tes articles àune heure ben tardive ! :)

Zend Framework Pagination, third strike - Erik

Erik — Sun, 23 Sep 2007 11:18:27 +0200

Once again thanks for the code. I think you mean previous() instead of prev() though.

Another small fix, if you have 2 tables that don’t completely map together (ex: you have a log table that maps it’s user id to a user table, if one of the user ids doesn’t exist the log row will get ignored) the fetchAll will return the filtered rows and the fetchCount will return them all (in my case fetchAll returned 260 and fetchCount returned 262, so I had 1 extra page that had no entries)

To fix it you just need to apply the parent mapping to fetchCount, I had to also add a variable to _applyParentMap so it didn’t try to select the mapped fields when selecting the count.

http://code.ryvondesigns.com/riskle...
http://code.ryvondesigns.com/riskle...

Also, while I was attempting to fix this I might’ve stumbled upon an easier way to apply the parent map to fetchRow and fetchAll. First I removed fetchAll , fetchRow, and _makeRowset. Then I added a copy of Zend_Db_Table_Abstract’s _fetch method with _applyParentMap inside it. It seemed to work fine in my tests, I didn’t include it in the patch since I haven’t tested it much but you might want to look at it sometime.

Zend Framework Pagination reloaded - Geoffrey

Geoffrey — Fri, 14 Sep 2007 11:55:04 +0200

Hi Rvo, Urls is a class of mine extending Zend_Db_Table (ZDT). You can pass any class extending ZDT to the pagination component.

Zend Framework Pagination reloaded - Rvo

Rvo — Thu, 13 Sep 2007 13:58:31 +0200

Maybe I'm stupid but where does 'new URLs' come from in 'new Riskle_Db_Table_Paginate(new URLs, $this->_getParam('page'));' ?

I just can't find it anywhere :/

Zend_Db_Table and tables relationships - Geoffrey

Geoffrey — Sat, 08 Sep 2007 17:46:34 +0200

thanks for the patch, I'll apply it soon :)

Zend_Db_Table and tables relationships - Erik

Erik — Fri, 07 Sep 2007 19:32:22 +0200

Thanks for the code, it has come in useful. Here is modified version with a addition of fetchRow that handles the relationships. (the actual mapping was moved from fetchAll to a class member)

http://code.ryvondesigns.com/riskle...
http://code.ryvondesigns.com/riskle...