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
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)
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
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
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;
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),