CakePHP Questions

Hello,

Basically I'm wondering if there's an easy way to do 2 things. I have a two tables, submissions and users joined by a HABTM relationship via submissions_users.

EDIT: Figured this part out

___________________________

Now say, for efficiency, when I'm getting a large list of submissions and their associated users, is there any way for me to specify which fields in the users table to fetch? By default when I do $this->Submission->find('all') it'll grab ALL the fields in the Users table (a lot) when all I really need are name and id. Is there an easy way to specify this or would I have to go through the submissions results 1 by 1 on a lower recursive value and fetch the associated users 1 by 1?

---------------------------

STILL wondering about this ->

On the same note, can I specify fields in a related table as a condition for a query? For example, I have a field in submissions called subtype_id that refers to a table called subtypes (via hasOne). Would it be possible when I do $this->Submission->find() for me to specify, say Subtype.name = 'Audio' or something? It seems that if I have to hardcode in the id's of various types of submissions so that I can run the query more easily kind of defeats the purpose of associating a table with it.

Thanks!