iyah sih, emang itu lebih baik kayanya. jadinya codingnya lebih banyak
deh, hehehehe.
On Oct 19, 2009, at 6:43 AM, Dwinanto Santoso wrote:
> kalo saya mungkin akan coba metode yg pragmatic aja,
>
> ubah: @search = Student.search(params[:search])
>
> misalnya dengan ID sehingga kita tau kalo query-nya bener, jadi klo
> sampe salah masalah-nya di view-nya. (walau dari message error mungkin
> bukan di view)
> kalo misalnya dengan ID dah benar artinya ada yg salah dengan yg
> diatas,
> mungkin harus diliat di log-nya query apa yg terbentuk.
>
> terus copy query tersebut dan eleminasi satu2 per satu sehingga
> ketauan
> masalahnya apa.
>
> On 10/19/2009 6:17 AM, Bobby Adi Prabowo wrote:
> >
> > kalau saya jalankan di script console seperti ini
> >
> > >> Student.search
> > ("name_like"=>"bob") =>
> > #<Searchlogic::Search:0x103111d00 @conditions={:name_like=>"bob"},
> > @current_scope=nil, @klass=Student(id: integer, student_no: string,
> > register_date: date, name: string, place_birth: string, date_birth:
> > date, address: text, phone_number: string, handphone_number: string,
> > school_id: integer, grade: string, father_name: string, mother_name:
> > string, status: boolean, created_at: datetime, updated_at: datetime,
> > photo_file_name: string, photo_content_type: string,
> photo_file_size:
> > integer, photo_updated_at: datetime)
> >
> > itu bisa, namun jika saya tambahkan dengan params yang di passing
> oleh
> > date_select, maka menjadi :
> >
> > >> Student.search("name_like"=>"bob", "register_date_equals
> > (1i)"=>"2005","register_date_equals(2i)"=>"1", "register_date_equals
> > (3i)"=>"2") NoMethodError: You have a nil object
> > when you didn't expect it!You might have expected an instance of
> > ActiveRecord::Base.The error occurred while evaluating nil.[]
> > from /usr/local/lib/ruby/gems/1.8/gems/searchlogic-2.3.5/lib/
> > searchlogic/search.rb:128:in `condition_name'
> > from /usr/local/lib/ruby/gems/1.8/gems/searchlogic-2.3.5/lib/
> > searchlogic/search.rb:82:in `method_missing'
> > from /usr/local/lib/ruby/gems/1.8/gems/searchlogic-2.3.5/lib/
> > searchlogic/search.rb:67:in `send'
> > from /usr/local/lib/ruby/gems/1.8/gems/searchlogic-2.3.5/lib/
> > searchlogic/search.rb:67:in `conditions='
> > from /usr/local/lib/ruby/gems/1.8/gems/searchlogic-2.3.5/lib/
> > searchlogic/search.rb:64:in `each'
> > from /usr/local/lib/ruby/gems/1.8/gems/searchlogic-2.3.5/lib/
> > searchlogic/search.rb:64:in `conditions='
> > from /usr/local/lib/ruby/gems/1.8/gems/searchlogic-2.3.5/lib/
> > searchlogic/search.rb:50:in `initialize'
> > from /usr/local/lib/ruby/gems/1.8/gems/searchlogic-2.3.5/lib/
> > searchlogic/search.rb:25:in `new'
> > from /usr/local/lib/ruby/gems/1.8/gems/searchlogic-2.3.5/lib/
> > searchlogic/search.rb:25:in `search'
> > from (irb):6
> >
> > apa berarti date select tidak cocok dengan searchlogic, atau teknik
> > pemakaian yang saya gunakan salah?
> >
> > On Oct 18, 2009, at 11:08 PM, Arie Kusuma Atmaja wrote:
> >
> > > 2009/10/18 Bobby Adi Prabowo <[email protected]
> > <mailto:tigaenamb%40gmail.com>>:
> > >
> > > > oh begitu yah.
> > > > padahal pada controllernya methodnya seperti ini
> > > >
> > > > def index
> > > > @search = Student.search(params[:search])
> > > > @students = @search.all.paginate :page => params
> > > > [:page], :per_page => 10, :order => 'id DESC'
> > > >
> > > > respond_to do |format|
> > > > format.html # index.html.erb
> > > > format.xml { render :xml => @students }
> > > > end
> > > > end
> > >
> > > Kalau sudah begitu berarti periksa apakah Anda mengiterate Array
> > > kosong. Caranya biar Anda langsung dengan cepat lihat dari
> > > script/console atau script/runner aja dan jalankan class method
> search
> > > dari Student class tsb di console Anda. Jangan lupa Anda harus
> selalu
> > > tail -f log/development.log buat lihat SQL Query nya seperti apa
> > > hasilnya .
> > >
> > > > The error occurred while evaluating nil.[]
> > >
> > > May The Force be with you. http://bit.ly/Oue4s <http://bit.ly/Oue4s
> >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
[Non-text portions of this message have been removed]
