Shouldn't getList be more like
function getList() {
$return = $this->generateList(null,null,
100,'{n}.App.app_id','{n}.App.app_name');
$this->set('return',$return); // not sure what you are trying here
but it probably isn't setting $return
return $return;
}
HTH,
David Lloyd
--
lloydhome consulting
http://lloydhome.com
On Feb 7, 7:06 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Hey everyone,
>
> I've been trying to find an answer to this all day with no luck, so I
> thought I'd poll the great minds on this list to see if anyone knows
> what's going on here...
>
> What I've got: I'm working on a service request form, trying to build
> a drop down selection box on the web form using data from a table
> (Model) that is not part of my current Model/Controller/View. The
> data resides in the Model "App" and I'm using the Model "Request".
> What I'm trying to do is grab all the values (rows) from
> App.app_name. (This table is very simple, it has two columns "app_id"
> and "app_name".)
>
> Basically I want the selectTag method to build a selection box with
> the query SELECT app_name FROM apps, the problem is that cakePHP is
> constructing a query like SELECT app_name FROM apps WHERE request_id =
> 'x'
>
> What I've tried: I've tried adding:
>
> var $hasMany = array('App' => array(
>
> 'className' => 'App',
>
> 'conditions' => null,
>
> 'order' => null,
>
> 'limit' => null,
>
> 'foreignKey' => 'app_id',
>
> 'dependent' => false,
>
> 'exclusive' => false,
>
> 'finderQuery' => ''
> )
> );
>
> This code causes the where clause to be inserted where I do not want
> it to be.
>
> I also have this in my Results Controller file to try and assign the
> data into a variable to be used in my view:
>
> $this->set('list',$this->Request->App->getList()) <---- which calls a
> function in my App controller that looks like:
>
> function getList() {
> $this->set('return', $this->generateList(null,null,
> 100,'{n}.App.app_id','{n}.App.app_name');
> return $return;
>
> }
>
> So my first problem is how in the world do I force this to pull back
> the entire contents inside the apps table (there are only four rows in
> this table, so it's not a lot of data).
>
> Then my second problem is getting a select box built with selectTag?
> Currently I have this in my code:
>
> $html->selectTag('Request/App/app_name',
> $list',null,array(),null,false,false)
>
> but of course, that's not working right now.
>
> This post may be a bit fragmented right now, so if anyone has any
> thoughts on how to sort all of this out but needs more info, please
> let me know!
>
> Thank you!
>
> --Patrick Holt
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
