Re: [JDBC] How to set numeric in PreparedStatement

2001-03-22 Thread Aaron Brashears
On Thu, Mar 22, 2001 at 10:12:16AM +0200, Juhan-Peep Ernits wrote: > > May be this would help? > > "select id from account where balance > ?::numeric(10,2) and > balance < ?::numeric(10,2)"; > > > Juhan Ernits > Perfect! Thank you, it works great. I've never seen that syntax before, i

Re: [JDBC] How to set numeric in PreparedStatement

2001-03-22 Thread Juhan-Peep Ernits
On Wed, 21 Mar 2001, Aaron Brashears wrote: > PreparedStatement pstmt = connectoin.prepareStatement( > "select id from account where balance > ? and balance < ?"; > pstmt.setDouble( 1, 10.0 ); > pstmt.setDouble( 2, 100.0 ); > ResultSet rs = pstmt.executeQuery(); > ... > > And fin