I agree, I'm not sure what it's doing either, it's a suggestion I
found somewhere else yesterday (which obviously isn't doing
anything...) In fact, even with the change you've suggested below,
I'm still getting a message from the debug output that indicates.
getList 1064: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'getList' at line 1 0
I guess, assuming that all of my code above is flawed, does anyone
have a suggestion on building a select list based on a two-column
table with four rows of data (may have five or six rows in the future,
but never more than 10), and how to get this data out with the $html-
>selectTag() method?
Thanks,
--P
On Feb 7, 7:32 pm, "lloydhome" <[EMAIL PROTECTED]> wrote:
> 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 consultinghttp://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 [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
-~----------~----~----~----~------~----~------~--~---
