ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Graeme J Sweeney <ibatis.u...@gjsweeney.com>
Subject RE: iBatis gives no error but no results!
Date Wed, 14 Nov 2007 16:00:03 GMT
On Wed, 14 Nov 2007, lucy.foster@uk.abnamro.com wrote:

> Thanks Graeme.  It appears to be a problem with the Strings.  On hardcoding
> #family#, #group# and #type# with the actual Strings but using
> #firstContractId# and #secondContractId# as params it works.  However
> setting the Strings as params and hardcoding the numbers for the between
> statement it doesn't work.

Which database/driver?

Maybe you need to hint at the type (can't see why for a String),

try #family:VARCHAR# from [1].

[1] Inline Parameter Map Syntax
http://ibatis.apache.org/docs/java/pdf/iBATIS-SqlMaps-2_en.pdf

-- 
Graeme -

Mime
View raw message