G'day Just for closing, restructure of the table was required, then the folks I was doing this for dropped the requirement............
On Nov 16, 8:08 am, ldb <[EMAIL PROTECTED]> wrote: > G'day > > Ah, should have mentioned, I can restructure the table if that is > needed, was trying not to. Been through too much trying to figure this > one out, restructure would have to be less trouble if it makes Cake > happier and works better within it's format. > > Thanks...;-) > > On Nov 16, 8:04 am,ldb<[EMAIL PROTECTED]> wrote: > > > G'day > > > Thanks. I have already applied the setup from devmoz, it was very > > helpful and I have the example working and another copy where the two > > tables involved actually can use a "belongs to" just as an extra test. > > I have likely not explained this fully, sorry. I have a table with > > model numbers & other info on the products called "models", then I > > have a table which only contains three columns, "ID", "Model Number" > > and "Other Model Number" called "Altmodels", so that items that are > > comparable could be looked up and interchanged. The "ID" number is an > > autoincrement, "Model Number" and "Other Model Number" can occur > > several times in all possible combinations. Any reference to the codes > > would point back to the "Models" table, it's really just a kind of > > index. > > > I could not determine a fit with the associations ( I could be > > missing something there) so I set up the generateList to accommodate > > this and realized that upon load, how do I tell the lower two lines > > the model code selected by default? Or can I. Maybe I am on the wrong > > track with that part and don't need those lines? I am using > > scriptaculous and have verfied that it is working within this cake > > project. I have done PHP b ut just started with Cake, I figure I'm > > abusing it but not sure how. > > > On Nov 16, 1:44 am, francky06l <[EMAIL PROTECTED]> wrote: > > > > You probably need an ajax call to update the 2 boxes when the value of > > > your first box changes. > > > See a sample here > > > :http://www.devmoz.com/blog/2007/04/04/cakephp-update-a-select-box-usi... > > > > On Nov 15, 10:29 pm,ldb<[EMAIL PROTECTED]> wrote: > > > > > G'day > > > > > I just can't seem to find the right answer to this one. Hopefully > > > > someone can point me in the right direction please. I have the > > > > following function in a "app/controllers/models_controller.php". I > > > > load three select boxes two of which rely on data from the first one. > > > > I can enter a manual value into the array as you can see, and they > > > > display the data fine, but I can't seem to figure out how to capture > > > > the value of the current selected item from the first generateList to > > > > feed it to the two others. > > > > > Can someone please enlighten me?.........;-) > > > > > function index() { > > > > $this->set('models', > > > > $this->Modelinfo->Model->generateList(null, 'Model_Number', null, > > > > > '{n}.Model.Model_Number','{n}.Model.Model_Number', true, true ) ); > > > > > $this->set('modelinfos', > > > > $this->Modelinfo->generateList(array('Modelinfo.Model_Number'=> > > > > 'LD400'),null, null, > > > > > '{n}.Modelinfo.Model_Number','{n}.Modelinfo.AltModel_Number')); > > > > > $this->set('altmodels', > > > > $this->Altmodel->generateList(array('Altmodel.Model_Number'=> > > > > 'LD400'),null, null, > > > > > '{n}.Altmodel.Model_Number','{n}.Altmodel.Alt_Model')); > > > > > } > > > > > Thanks.... > > > > -- > > > >ldb --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
