Ignore that last one responded to fast that will not work
On Mon, Jun 16, 2008 at 2:53 PM, Nathan Maves <[EMAIL PROTECTED]>
wrote:
> can you not do
>
>
>select * from mytable
>
>
>
>field1 = prop1
>
can you not do
select * from mytable
field1 = prop1
field2 = prop2
field3 = prop3
Ah, I see.
Unfortunately there is not short handed way around this. Your suggestions
are the best way to get around it. I know it doesn't help a whole lot but we
are aware of these shortcomings and looking to nullify them in iBATIS 3.
I'll try to take a little time to look into nested dynamic tags
I'm not sure about other database systems, but MySQL (5) will throw an
error for this query:
select * from mytable where () and field3 = prop3
Is Ibatis smart enough to remove the "(" and ")" when the contents are
empty?
One workaround is to put this in the parentheses, but this is an ugly
ha
Can you please explain the reason you need the nested dynamic tag?
Why not simply do this?...
select * from mytable
(
field1 = prop1
