Your code looks a bit non-standard. What's ItemKey1? And field name are normally lower camel case.
Try this (assuming you primary key on the items table is 'id' and your description field is 'item_description'): public function view($id = null) { $this->set( 'item', $this->Item->find( 'first', array('Item.id' => $id) ) ); } Then in your view: <?php echo $this->Html->link( $item['Item']['item_description'], array( 'controller' => 'items', <=== note the controller is all lower case 'action' => 'view', $item['Item']['id'] ) ); ?> Jeremy Burns Class Outfit http://www.classoutfit.com On 4 Dec 2011, at 23:2743, davfergus wrote: > Good evening, > > Rookie developer, in MVC for 6 months, CakePHP for about 1. My > current tests with Cake can be seen at: http://174.129.130.149/items > > I am experiencing an issue on the drill down. I paste everything into > a text doc so I could do a line by line but the issue is eluding me. > > I can successfully see all items of my table. I can click the link > and go from index.ctp to view.ctp. My id passes successfully. No db > data shows on view.ctp, but there are no errors. The test var in item > 2 below displays. I cast $id as an (int) and did a gettype to test, > and it came back as an int. Still no luck? I am assuming I am > missing something quite simple, but after three hours of looking at > this I obviously do not know what I am looking at. > > 1. app/Model/Item.php > > class Item extends AppModel { > public $name = 'Item'; > } > > 2. app/Controller/ItemsController.ctp contains the following (index() > works like a champ): > public function view($id = null) { > $this->Item->ItemKey1 = $id; > $this->set('item', $this->Item->read()); > $this->set('testvar', 'it is set'); > } > > index successfully executes find('all'); > > 3. app/View/Items/view.ctp contains the line: echo $item['Item'] > ['DBField']; and echo $testvar; > > a. index.ctp does the following: <?php echo $this->Html- >> link($item['Item']['ItemDescription'], array('controller' => 'Items', > 'action' => 'view', $item['Item']['ItemKey1']) ); ?> > the link works and I go to the correct page, I do a view source > and everything is there minus any data from the db. I've tried > changing item names to upper case, adding an 's', but each changes > throws an error. I thought the issue was the id coming in as a string > so I cast to an int, still no dice. > > R/s, > Dave > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group at > http://groups.google.com/group/cake-php -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php