search for: paranethesis

....find_by_sql ["select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT * FROM componentlog WHERE (cl_compname like ?) ORDER BY cl_spr DESC ) raw_sql_ where rownum <= ? ) where raw_rnum_ > ? )", criteria, limit, offset] Which mimicks the error SQL with with an extra right paranethesis but I still get the same error. Can any SQL guru give me a helping hand? Thanks Jeff -- Posted via http://www.ruby-forum.com/.