Hello,
I've decided to take a stab at developing with CakePHP instead of re-
inventing the wheel every time I develop a site. So far I've been very
impressed with everything it can do, and how great the organization
is.
Currently I'm trying to do the blog example, however with my own
table. Reason being is anyone can copy/paste code, however I'd like to
really understand the "why".
I'm up to the point where I implement the the ability to view a blog
post within a view and I'm having some troubles.
First off, here's my table:
[code]
CREATE TABLE IF NOT EXISTS `supa_supa`.`blog_posts` (
`blog_posts_id` BIGINT(12) NOT NULL ,
`blog_id` BIGINT(12) NOT NULL ,
`author_id` BIGINT(12) NULL ,
`author_type` VARCHAR(45) NULL ,
`date_created` DATETIME NULL ,
`date_modified` DATETIME NULL ,
`title` VARCHAR(128) NULL ,
`description` VARCHAR(256) NULL ,
`header` TEXT NULL ,
`body` TEXT NULL ,
`footer` TEXT NULL ,
PRIMARY KEY (`blog_posts_id`) ;
[/code]
Here's my function from my blog_posts_controller.php
[code]
function view($BlogPostId = null) {
$this->BlogPost->BlogPostId = $BlogPostId;
$this->set('BlogPost', $this->BlogPost->read());
}
[/code]
And finally my view:
[code]
<h1><?php echo $BlogPost['BlogPost']['title']?></h1>
<p><small>Created: <?php echo $BlogPost['BlogPost']['date_created']?></
small></p>
<p><?php echo $BlogPost['BlogPost']['body']?></p>
[/code]
Now I'm receiving the following error, and no matter how I change
variable names in the view() function the error is constant.
Warning (512): SQL Error: 1054: Unknown column 'BlogPost.id' in 'where
clause' [CORE/cake/libs/model/datasources/dbo_source.php, line 440]
The query it's attempting is:
SELECT `BlogPost`.`blog_posts_id`, `BlogPost`.`blog_id`,
`BlogPost`.`author_id`, `BlogPost`.`author_type`,
`BlogPost`.`date_created`, `BlogPost`.`date_modified`,
`BlogPost`.`title`, `BlogPost`.`description`, `BlogPost`.`header`,
`BlogPost`.`body`, `BlogPost`.`footer` FROM `blog_posts` AS `BlogPost`
WHERE `BlogPost`.`id` = 1 LIMIT 1
Have I committed a naming faux pas by having my PK blog_posts_id ? The
index that uses findAll() works like a charm, it's just this view that
I can't seem to get working.
Thanks,
Mark
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
