[fw-general] [ZF2] Paginator DbSelect not counting rows as expected

2012-11-20 Thread Jean Rumeau
Hello, today i started addings records to a database to test the pagination component. The dbselect query im passing to the adapter as string is this: SELECT `i`.*, `c`.`name` AS `categoryName`, CASE WHEN COUNT(bhi.id) 0 THEN 1 ELSE 0 END AS `used` FROM `items` AS `i` INNER JOIN `categories` AS

Re: [fw-general] [ZF2] Paginator DbSelect not counting rows as expected

2012-11-20 Thread Ralph Schindler
What database are you using? It might be an issue, but it's hard to tell: * what database? (it looks like mysql quoting) * do you think it's an issue that you're also using `c` just like the dbselect adapter as an alias? does it change the output if you change your alias? (Paginator uses c)

[fw-general] Re: [ZF2] Paginator DbSelect not counting rows as expected

2012-11-20 Thread Jean Rumeau
Hey Ralph thanks for replying. Im using MySQL I did try changing the alias, but the query ended up being the same just with another alias for categories. I thought it my be a problem with my grouping but the query works well without pagination. I think the adapter should wrap the original

[fw-general] Zend Framework 2.0.4 Released!

2012-11-20 Thread Matthew Weier O'Phinney
We've just pushed the bits for the 2.0.4 release -- you can read more about it here: http://framework.zend.com/blog/zend-framework-2-0-4-released.html If you have been using either the JsonStrategy or FeedStrategy, please read the release notes carefully, as you may need to make changes in

[fw-general] Learning Zend Framework 1

2012-11-20 Thread Joseph Pond
Hello, I'm intersted in learning Zend Framework 1. I am currently a CS major who is trying to get a position with a company that uses ZF1 abundantly. I have done a lot of studying of the page http://framework.zend.com/manual/1.12/en/manual.html. That website is a great reference for ZF1;

Re: [fw-general] Learning Zend Framework 1

2012-11-20 Thread Thomas Mauro Vargiu
Hello, In ZF1 you are free to write your own model. Maybe you need to create object representation of db table rows. to do this create classes for db tables that extends Zend_Db_Table_Abstract and then you can specify what class to use for table rows (a class that extends Zend_Db_Table_Row),