Re: how do I handle foreign keys??
Try using $form-select('Entry.category_id', ...)
http://manual.cakephp.org/view/182/form
http://api.cakephp.org/class_form_helper.html#5171e675468c9665db0653c165b6c89c
Any if you get stuck, read this one too:
http://groups.google.com/group/cake-php/browse_thread/thread/fb6b71db2de8392d/eec7b739313c283f
On Jun 20, 2:35 am, Turnquist, Jonah [EMAIL PROTECTED] wrote:
Also i should note that right now it's just showing a text box, no
drop down
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: how do I handle foreign keys??
Make sure your associations aren't backwards.
Read http://book.cakephp.org/view/66/models#associations-78 ,
compare foreignKey for hasOne and belongsTo.
On 20 Jun 2008, at 09:34, Turnquist, Jonah wrote:
I have a 'entries' table and a 'categories' table. I am creating an
'add' page to add a new entry, and I want to be able to select the
category that the entry goes into.
View:
h1Add Entry/h1
?php
echo $form-create('Entry');
echo $form-input('category_id');
echo $form-end('Submit');
?
Model:
?php
class Entry extends AppModel
{
var $hasOne = 'Category';
var $validate = array(
);
}
?
Category modal:
?php
class Category extends AppModel
{
var $validate = array(
);
}
I want the add page to show a drop down menu of all the availiable
categories in the categories table, what am i doing wrong?
Thanks,
Jonah
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: how do I handle foreign keys??
Eh, it did not work. And I read those pages, it does not seem to tell
me. Do I need to do this manually using find() to find all the
categories and than pass those to the input through 'options' or will
cake do some magic because of my $belongsTo definition? Also, if I do
it manually, how would I call the Categories modal from the Scripts
controller? This obviously did not work in my Scripts controller:
$this-Category-find('all', array('recursive' = -1));
Thanks,
Jonah
On Jun 20, 12:40 am, dr. Hannibal Lecter [EMAIL PROTECTED]
wrote:
Try using $form-select('Entry.category_id', ...)
http://manual.cakephp.org/view/182/formhttp://api.cakephp.org/class_form_helper.html#5171e675468c9665db0653c...
Any if you get stuck, read this one too:
http://groups.google.com/group/cake-php/browse_thread/thread/fb6b71db...
On Jun 20, 2:35 am, Turnquist, Jonah [EMAIL PROTECTED] wrote:
Also i should note that right now it's just showing a text box, no
drop down
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: how do I handle foreign keys??
On Fri, Jun 20, 2008 at 10:33 PM, Turnquist, Jonah [EMAIL PROTECTED] wrote:
Eh, it did not work. And I read those pages, it does not seem to tell
me. Do I need to do this manually using find() to find all the
categories and than pass those to the input through 'options' or will
cake do some magic because of my $belongsTo definition? Also, if I do
it manually, how would I call the Categories modal from the Scripts
controller? This obviously did not work in my Scripts controller:
$this-Category-find('all', array('recursive' = -1));
It looks to me like you're trying to generate a list of things for
your form. If so, try this from your scripts controller:
$this-Entry-Category-recursive = -1;
$results = $this-Entry-Category-find('list');
Make sure that you've set the $uses variable in your Scripts
controller to tell it you want to use Entry.
class ScriptsController extends AppController {
var $uses = array('Entry', ...)
...
}
Hope that helps.
--
Chris Hartjes
Internet Loudmouth
Motto for 2008: Moving from herding elephants to handling snakes...
@TheKeyBoard: http://www.littlehart.net/atthekeyboard
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: how do I handle foreign keys??
Ok, it works now. I guess $uses is what I was missing. Thanks
On Jun 20, 8:08 pm, Chris Hartjes [EMAIL PROTECTED] wrote:
On Fri, Jun 20, 2008 at 10:33 PM, Turnquist, Jonah [EMAIL PROTECTED] wrote:
Eh, it did not work. And I read those pages, it does not seem to tell
me. Do I need to do this manually using find() to find all the
categories and than pass those to the input through 'options' or will
cake do some magic because of my $belongsTo definition? Also, if I do
it manually, how would I call the Categories modal from the Scripts
controller? This obviously did not work in my Scripts controller:
$this-Category-find('all', array('recursive' = -1));
It looks to me like you're trying to generate a list of things for
your form. If so, try this from your scripts controller:
$this-Entry-Category-recursive = -1;
$results = $this-Entry-Category-find('list');
Make sure that you've set the $uses variable in your Scripts
controller to tell it you want to use Entry.
class ScriptsController extends AppController {
var $uses = array('Entry', ...)
...
}
Hope that helps.
--
Chris Hartjes
Internet Loudmouth
Motto for 2008: Moving from herding elephants to handling snakes...
@TheKeyBoard:http://www.littlehart.net/atthekeyboard
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
how do I handle foreign keys??
I have a 'entries' table and a 'categories' table. I am creating an
'add' page to add a new entry, and I want to be able to select the
category that the entry goes into.
View:
h1Add Entry/h1
?php
echo $form-create('Entry');
echo $form-input('category_id');
echo $form-end('Submit');
?
Model:
?php
class Entry extends AppModel
{
var $hasOne = 'Category';
var $validate = array(
);
}
?
Category modal:
?php
class Category extends AppModel
{
var $validate = array(
);
}
I want the add page to show a drop down menu of all the availiable
categories in the categories table, what am i doing wrong?
Thanks,
Jonah
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: how do I handle foreign keys??
Also i should note that right now it's just showing a text box, no drop down --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
