noentrynoentrynoentry'
strings.
Think I'm just going to close my
eyes tightly and pretend it never happened. J
-Original
Message-
From: Fabio Insaccanebbia
[mailto:[EMAIL PROTECTED]]
Sent: 12 September 2006
17:23
To: user-java@ibatis.apache.org
Subject: Re: Search screen
’
strings.
Think I’m just going to close my
eyes tightly and pretend it never happened. J
-Original
Message-
From: Fabio Insaccanebbia
[mailto:[EMAIL PROTECTED]]
Sent: 12 September 2006 17:23
To: user-java@ibatis.apache.org
Subject: Re: Search screen : HOW TO
Just a couple
Just a couple of questions..Is the pmp.MANUFACTURE_PROCESS_ID field indexed?
Are the field values equally distributed?
If the answers are (yes, no) and you're using Oracle, maybe you're having a problem with a skewed index.
Added each "dynamic" line in one by one, and it was ok until I addedpmp.MA
-Original Message-
From: Paul Carr [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 12 September 2006 08:14
To: user-java@ibatis.apache.org
Subject: RE: Search screen : HOW TO
I have tried modifying the query so that the only "dynamic" bit is
(jow.JOB_STATUS_C =#jobStatC:INTEGER# or #jobSta
hanks
Muthu
-Original Message-
From: Paul Carr [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 12, 2006 5:44 PM
To: user-java@ibatis.apache.org
Subject: RE: Search screen : HOW TO
I have tried modifying the query so that the only "dynamic" bit is
(jow.JOB_STATUS_C =#jobSt
M Muthukumaran [mailto:[EMAIL PROTECTED]
Sent: 12 September 2006 12:46
To: user-java@ibatis.apache.org
Subject: RE: Search screen : HOW TO
For furthur clarification, What happens when we hardcode the
JOB_STATUS_C in xml file like
<.."jow.JOB_STATUS_C = 0 or #jobStat
I don't know the exact syntax, please do check some documentation if it
is useful.
Thanks
Muthu
-Original Message-
From: Paul Carr [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 12, 2006 5:03 PM
To: user-java@ibatis.apache.org
Subject: Search screen : HOW TO
HiAll,
HiAll,
I'm developing a JSP screen to allow users to search a database
of orders on various criteria. There are several text boxes on the
screen where you can enter things like
Item id
Barcode id
Date
Process id
Etc
And click search the backend then runs this SQL query:-
select
