From: Ryan Lewis Date: 2008-05-30T22:34:27+09:00 Subject: Re: How do i replace actual value in the query with variable or even: (0..4).each { |q| conn.exec( 'UPDATE SCH_EVENT SET P_ID = 2444334 where RANK = #{q.to_f} AND playlist_id = 432' ) } <3 one liners -- Posted via http://www.ruby-forum.com/.