# No Method Error in MasterkeysController#search

**URL:** <https://www.ruby-forum.com/t/no-method-error-in-masterkeyscontroller-search/187065>\
**Category:** Rails\
**Created:** [April 16, 2010, 2:05pm UTC](https://www.ruby-forum.com/t/no-method-error-in-masterkeyscontroller-search/187065 "2010-04-16T14:05:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sandeep\_ndd](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/c67d28/32.png) [@sandeep\_ndd](https://www.ruby-forum.com/u/sandeep_ndd)\
**Post date:** [April 16, 2010, 2:05pm UTC](https://www.ruby-forum.com/t/no-method-error-in-masterkeyscontroller-search/187065/1 "2010-04-16T14:05:16Z")

</div>

undefined method `pin’ for “Masterkey\_2304”:String

Extracted source (around line #3):

1:

2: **Pin:**  
3: \<%=h @masterkey.pin %\>  
4:

  
5:  
6: 

RAILS\_ROOT: D:/CRIMPROF  
Request

Parameters:

{“Search”=\>“Search”,  
“pin”=\>“2304”}  
Response

Headers:

{“Content-Type”=\>“text/html”,  
“Cache-Control”=\>“no-cache”}  
please find the problem and my model looks like…  
class Masterkey \< ActiveRecord::Base  
has\_one :crimprofs  
set\_table\_name “MASTERKEY”  
set\_primary\_key :pin  
def self.find\_all\_elements(masterkey)  
tablename2 = masterkey  
find\_by\_sql [‘SELECT \* FROM ?’,tablename2]  
end

validates\_uniqueness\_of :pin, :scope =\> :pin  
end  
and My Controller looks like  
class MasterkeysController \< ApplicationController  
protect\_from\_forgery :only =\> [:create, :delete, :update]

# GET /masterkeys

# GET /masterkeys.xml

def index  
@masterkeys = Masterkey.all  
respond\_to do |format|  
format.html # index.html.erb  
format.xml { render :xml =\> @masterkeys }  
end

end

# GET /masterkeys/1

# GET /masterkeys/1.xml

def show  
@masterkey = Masterkey.find(params[:id])  
@rcn = @masterkey.rcn  
puts params[:id]  
puts @rcn  
respond\_to do |format|  
format.html # show.html.erb  
format.xml { render :xml =\> @masterkey }  
end  
end

# GET /masterkeys/new

# GET /masterkeys/new.xml

def new  
@masterkey = Masterkey.new

```
respond_to do |format|
  format.html # new.html.erb
  format.xml { render :xml => @masterkey }
end

```

end

# GET /masterkeys/1/edit

def edit  
@masterkey = Masterkey.find(params[:id])  
end

# POST /masterkeys

# POST /masterkeys.xml

def create  
hashMaster = params[:masterkey]  
@masterkey = Masterkey.new()  
@masterkey.pin=hashMaster[:pin]  
@masterkey.rcn = hashMaster[:rcn]  
respond\_to do |format|  
if @masterkey.save  
flash[:notice] = ‘Masterkey was successfully created.’  
format.html { redirect\_to(@masterkey) }  
format.xml { render :xml =\> @masterkey, :status =\> :created,  
:location =\> @masterkey }  
else  
format.html { render :action =\> “new” }  
format.xml { render :xml =\> @masterkey.errors, :status =\>  
:unprocessable\_entity }  
end  
end  
end

# PUT /masterkeys/1

# PUT /masterkeys/1.xml

def update  
@masterkey = Masterkey.find(params[:id])

```
respond_to do |format|
  if @masterkey.update_attributes(params[:masterkey])
    flash[:notice] = 'Masterkey was successfully updated.'
    format.html { redirect_to(@masterkey) }
    format.xml { head :ok }
  else
    format.html { render :action => "edit" }
    format.xml { render :xml => @masterkey.errors, :status =>

```

:unprocessable\_entity }  
end  
end  
end

# DELETE /masterkeys/1

# DELETE /masterkeys/1.xml

def destroy  
@masterkey = Masterkey.find(params[:id])  
@masterkey.destroy

```
respond_to do |format|
  format.html { redirect_to(masterkeys_url) }
  format.xml { head :ok }
end

```

end  
def search  
pin\_id= params[:pin]  
pin = pin\_id.to\_i  
@pin = Masterkey.find(pin)  
@masterkey = “Masterkey\_#{@pin.id}”  
puts @pin

```
@rcn = Masterkey.find_by_sql ("select rcn from masterkey where pin

```

=" + pin\_id)  
puts @rcn  
respond\_to do |format|  
format.html  
format.xml { render :xml =\> @masterkey }  
end  
end  
end

---

<div class="post-metadata">

**Author:** ![sandeep\_ndd](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/c67d28/32.png) [@sandeep\_ndd](https://www.ruby-forum.com/u/sandeep_ndd)\
**Post date:** [April 16, 2010, 2:24pm UTC](https://www.ruby-forum.com/t/no-method-error-in-masterkeyscontroller-search/187065/2 "2010-04-16T14:24:45Z")

</div>

In the view you can run \<%= debug(@masterkey) %\> to inspect the  
object, which will probably give you a clue to what the problem is