RE: discriminator and submap

2008-02-13 Thread Niels Beekman
onstraints out. Niels From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 13, 2008 6:37 PM To: user-java@ibatis.apache.org Subject: RE: discriminator and submap "Niels Beekman" <[EMAIL PROTECTED]> scritti il 12/02/2008 22:3

RE: discriminator and submap

2008-02-13 Thread c . zecca
"Niels Beekman" <[EMAIL PROTECTED]> scritti il 12/02/2008 22:37:21 > Hi, > > I?m not familiar with the decode function, but I would check the > ResultSet debug logging and see if ?decode( IDENTIFICATORI_VALORE. > TIPO_RIGA_ID, null, 0, 1) as DI_TIPO_RIGA? actually returns the > results you?re e

RE: discriminator and submap

2008-02-12 Thread Niels Beekman
om: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 12, 2008 7:07 PM To: user-java@ibatis.apache.org Subject: Re: discriminator and submap > Niels Beekman > Sat, 04 Nov 2006 03:35:52 -0800 > If only if/else behaviour is required, why not create an additio

Re: discriminator and submap

2008-02-12 Thread c . zecca
> Niels Beekman > Sat, 04 Nov 2006 03:35:52 -0800 > If only if/else behaviour is required, why not create an additional > column? Something like: [...] Hi all Following the Niels' suggestion I wrote the map and query (see below) A column TIPO_RIGA_ID of the table IDENTIFICATORI_VALORE is nullabl

RE: discriminator and submap

2006-11-06 Thread Christopher . Mathrusse
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: zaterdag 4 november 2006 1:42To: user-java@ibatis.apache.orgSubject: RE: discriminator and submap   Well I did something similar but I still need to perform the 'else'.               My problem is that the above will apply the

RE: discriminator and submap

2006-11-04 Thread Niels Beekman
: zaterdag 4 november 2006 1:42 To: user-java@ibatis.apache.org Subject: RE: discriminator and submap   Well I did something similar but I still need to perform the 'else'.               My problem is that the above will apply the resultMap if the field part_no is null, but how do

RE: discriminator and submap

2006-11-03 Thread Christopher . Mathrusse
e values I only want a simple if/else basically. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of "Larry Meadors" <[EMAIL PROTECTED]>Sent: Friday, November 03, 2006 4:31 PMTo: user-java@ibatis.apache.orgSubject: Re: discriminator and submap I'd

Re: discriminator and submap

2006-11-03 Thread Larry Meadors
I'd probably do something like NVL(field, 'someMagicNullString') in the sql to make sure that it wasn't null. :-/ Crude, but effective. Larry On 11/3/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Can I use the discriminator and sub map to test for null values? Meaning if I define the dis