Data retrieval with :conditions

Hi Martyn,

Martyn Elmy-liddiard wrote:

Obviously my Model code is wrong

No offense intended, but there're problems with all your code.

<form action="/risk/liststatus2">
Status <input type="text" name="Status" size="20"><p>
<input type="submit">
</form>

You're hardcoding your form instead of using eRb. Rails will have a hard time figuring out what you're asking it to do. You'll need to decide whether you want your params bound to a model or not: text_field vs. text_field_tag.

> In the Risk Controller I have the following Code:-

def liststatus2
@found = Risk.liststatus2
end

Params get passed back to the controller in a hash. In the case above, the value is coming back in a param you'd address like:

@found = params[:Status]

and finally in the Model I have the following code:-
def self.liststatus2
  find(:all, :conditions => "Status = ?", @Status)
end

The value is in @found.

hth,
Bill