From: Ror Ruby Date: 2009-10-31T15:21:05+09:00 Subject: get the fields from database My table name is pbook, in this i have lot fields ( 15 fields { name, homeno, pnoheno, mobileno, buisnessno, address, city, state), I have to implement the search facility, if the i type a pattern it should fetch the records from database, it should display the matched records. but my requirement is if my pattern match with atleast one field in pbook table it should display the records. give me a query. awaiting reply. Thx in advance, Manju.A. -- Posted via http://www.ruby-forum.com/.