Find_all_by and select boxes??

Hi Valerie,

So....let's have a look if I understood the issue:

-Find_all_by is actually the same like Find(:all), however Find_all_by
is much shorter and less complicated than the syntax of Find(:all)

-So in my CONTROLLER it says @files = find(:all) however I don't want
to see all files displayed in my selection box, because I only want to
see the foles whose mandant_id is the same like the mandant_id in
invoice.
So i decided to change the @files = find(:all) into =>
@files =File.find_all_by_mandant_id(Invoice.mandant_id)

Invoice is a class. What you're looking for is, I assume, the
mandant_id of a *particular* invoice. So you need to use the mandant_id
of that. Assuming you have grabbed that somewhere with another find
like ...

@my_invoice = Invoice.find(:first)

then your find_by will look like...

@files = File.find_all_by_mandant_id(@my_invoice.id)

Note that using 'File' as a model name is potentially problematic since
File is also a ruby class.

HTH,
Bill