Hi Paul I notice you've got both DeviceRepairs and DeviceRepair within your associations, this is likely your issue.
It's convention to have a singular model name i.e. *DeviceRepair, RepairType*, a plural controller name i.e. *DeviceRepairsController, RepairTypesController* and a plural table name i.e. *device_repairs, repair_types*, ofcourse it's not 100% strict and you can change this but you're more likely to run into issues. You can read more about naming conventions here http://book.cakephp.org/2.0/en/getting-started/cakephp-conventions.html On 11 September 2014 16:30, Paul Drage <[email protected]> wrote: > Cheers for that Mike, > > I tried containing and ran into lots of different issues, I then spent > about half an hour writing a REALLY UGLY javascript client side hack to do > my lookup for me (against a different set of results), it was fast becoming > a farce (see what i did there?) > > Would you be happy to consult? I had a quick look at your business > website, I'm really hoping it's something obvious.. > Let me know what you'd like to know - cheers > > > On Thursday, 11 September 2014 11:43:59 UTC+1, Mike Karthauser wrote: >> >> hi paul >> >> if you are using recursive =1 in you queries you won’t get all the info >> you need. I suggest you look at containable behaviour. ] >> >> http://book.cakephp.org/2.0/en/core-libraries/behaviors/containable.html >> >> BTW Its makes no odds which controller calls the model function. >> >> On 11 Sep 2014, at 11:03, Paul Drage <[email protected]> wrote: >> >> Should i just move everything to a different controller? surely there >> must be a way to do the association i need right in/before the query?? >> >> -- >> Like Us on FaceBook https://www.facebook.com/CakePHP >> Find us on Twitter http://twitter.com/CakePHP >> >> --- >> You received this message because you are subscribed to the Google Groups >> "CakePHP" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/cake-php. >> For more options, visit https://groups.google.com/d/optout. >> >> >> .................................... >> Mike Karthäuser >> Director, Brightstorm Ltd. >> >> 1, Brewery Court >> North Street >> Bristol >> BS3 1JS >> >> [email protected] >> www.brightstorm.co.uk >> +44(0) 7939252144 >> .................................... >> >> -- > Like Us on FaceBook https://www.facebook.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/cake-php. > For more options, visit https://groups.google.com/d/optout. > -- Kind Regards Stephen Speakman -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
