Recursive Pagination

Hi,

I am working on converting an existing script from classic php (its a
mess) to cakephp for a more clean cut,
lean running application. I am working on a view that shows Categories
and Items with recursive of 1.

I have managed to get my category view to show all the products under
each category with pagination
however, I need to filter the items being shown but I am not sure how
to do this.

I tried adding this in my category controller to filter by item:
$this->set('categories', $this->paginate('Category', array('Item.name
LIKE' => '%the%')));

but i get this error:
SQL Error: 1054: Unknown column 'Item.name' in 'where clause'

Can anyone point me in the right direction to get this working?

DATA EXAMPLE:

Alice Wonderland Belt Buckles
--------------------------------------------------------------------------------

Item(s):
Who Are You? Buckle
Through The Looking Glass Buckle
Alice & Humpty Buckle
Cheshire-Cat Buckle
The Mad Tea Party Buckle
Tweedle Dee & Tweedle Dum Buckle
The White Rabbit Buckle
Nothing But A Pack Of Cards Buckle
Art Buckles

--------------------------------------------------------------------------------

Item(s):
The Scream
Vitruvian Man Buckle
Mona Lisa Buckle
Pattern Belt Buckle
Pattern Belt Buckle
Creation of Adam
A Starry Night Picture Buckle
The Last Supper Buckle
Moon Man Buckle
Rose Belt Buckle
American Watch Co. Buckle
Automotive Belt Buckles

--------------------------------------------------------------------------------

Item(s):
Cadillac Emblem Belt Buckle
Cadillac Emblem Belt Buckle
Truck Drivers Move the Nation Buckle
Corvette Classics silver Belt Buckle
Red '57 Chevy Belt Buckle
Silver Chevy grille Belt Buckle
Chevy Belt Buckle
1959 Cadillac Classic Belt Buckle
Cadillac Belt Buckle
Yellow school bus Belt Buckle
Cement Truck Belt Buckle
Red Tow Truck Belt Buckle
Dump Truck Belt Buckle
Blue Semi Truck Belt Buckle
Corvette Belt Buckle
Red and Black Train Belt Buckle
55 Chevrolet Belt Buckle
Silver Chevy sign Belt Buckle
Chevy Buckle
Tractor Trailer Belt Buckle
Fire Fighter Truck Belt Buckle
Bulldozer Belt Buckle
Train Locomotive Brass Buckle
Truck Belt Buckle
Helicopter Belt Buckle
Chevy Trucks Belt Buckle
1994 Camaro Z28 Blue background
Chevy Z28 Belt Buckle
Van Belt Buckle
Peterbilt Belt Buckle
Peterbilt Belt Buckle
American Trucker Buckle
Truckin Aint For Sissies Buckle
Big Rig Buckle
Train Belt Buckle
Kenworth Belt Buckle
Kenworth Trucks Buckle
King Of The Road Buckle
Peterbilt Trucks Buckle
Hudson Steam Locomotive Buckle
Cadillac Belt Buckle
Chevrolet Corvette Circle Belt Buckle
Chevy Grille Buckle
Band Belt Buckles

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en