Database design question

2008-02-14 Thread judouk
Hi group I'm sure I've asked this before but, to save time (yours and mine!), I'm going to simplify this. My company sends out engineers to work on customer sites. When they get to site, they can do one of many things. I have listed each action in a table of its own, each scheduled visit in a

Controller confusion

2008-01-31 Thread judouk
$managers to create a select list. What I cant seem to work out is how to see the managers fullname instead of his/her userid. I believe this is because its not inside my projects model but I'm really not sure. I hope that is enough information. Any help would be gratefully received. Thanks JudoUK

Re: Controller confusion

2008-01-31 Thread judouk
On 31 Jan, 23:49, Matias Lespiau [EMAIL PROTECTED] wrote: I think your problem is that you're asking cake to just bring you the id's: Thanks I've tried that I now have $l = $this-Job-Manager-find('all', array('fields' = array('Manager.id', 'Manager.user_id', 'User.first_name',

View data via relationship

2008-01-25 Thread judouk
Hi All I have three tables (A,B,C) which each contain data. TABLE USER TABLE COMPANY TABLE JOB id id id b_id c_id job name cname I have taken advice from my

Database design considerations

2008-01-25 Thread judouk
Hi guys Before I start to create a database structure which I may end up changing, I wanted to run something past you all first. I have a list of jobs to do (JOBS). Each of these jobs may require one or more actions to complete it (ACTION). It would be nice to be able to report on how many

Re: Confused using forms (i think!)

2008-01-23 Thread judouk
Thanks all. I did more googling and ended up replacing the generateList() stuff with $l = $this-User-Usertype-find('all', array('fields' = array('Usertype.id', 'Usertype.choice'))); $result = Set::combine($l, {n}.Usertype.id, {n}.Usertype.choice); $this-set('usertypes',

Confused using forms (i think!)

2008-01-19 Thread judouk
Sorry guys - another newbie question. I've got an install of cake 1.2 I have a users table which I have associated with a usertypes table. My database setup (cut down for simplicity) is; create table usertypes ( id int(10) not null auto_increment, choice varchar(100) not null, ) type = myisam;