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
$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
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',
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
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
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',
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;