Thanks Clinton,
I will look into this myself when I have more time. I wish there were a MySql Profiler or something so that I could see what queries are actually being executed. Maybe I will step into your code if I get a chance.
KrisClinton Begin [EMAIL PROTECTED] wrote:
Kris,This is the right
Hello
this is what i tried
select * from test1 where
substring(type1,1,1) '0' and
substring(type1,2,1) '0'
i think it works
--- Larry Meadors [EMAIL PROTECTED] wrote:
Brute force?
select * from test1
where type1 not like '%1%'
and type1 not like '%2%'
and type1 not like '%3%'
PLEASE! PLEASE! PLEASE!
If you are not 99.999% sure it is a bug, do not put it in JIRA.
Larry
On 7/14/05, leo zhang (JIRA) ibatis-dev@incubator.apache.org wrote:
[
http://issues.apache.org/jira/browse/IBATIS-170?page=comments#action_12315824
]
leo zhang commented on IBATIS-170:
I think, it is not a bug :)
It doesn't work for me.
But this does
insert into testddo (col) values (to_date('2005-07-14 16:06:48','-mm-dd
hh24:mi:ss'));
hours: 16 should be declared as HH24 not hh
Anyway:)
Darek Dober
- Original Message -
From: Larry Meadors [EMAIL
p6spy is also a great sql logging tool.
On 7/14/05, Ron Grabowski [EMAIL PROTECTED] wrote:
The Java version of iBATIS has support for logging all sql sent to the
database. Here's some sample output:
http://issues.apache.org/jira/browse/IBATISNET-35
--- Kris Rasmussen [EMAIL PROTECTED]
Title: Using WHERE IN along with AND
I have the following select and it throws a UncategorizedSQL exception
select id=listDetailsForOrderIds parameterClass=java.util.List resultMap=list-rundetail-result
SELECT
R.ORD_ID AS ORD_ID,
PART_ID,
CLNT_ID_N,
PLAN_N,