I’m not here to defend the silly
operator, but there are more systems that use it, PostgreSQL for example…
Niels
From: Clinton Begin
[mailto:[EMAIL PROTECTED]
Sent: dinsdag 20 december 2005
17:12
To: user-java@ibatis.apache.org
Subject: Re: How to not verbosely
declare resultmaps?
Ack! Oracle and their silly concatination operator!
Cheers,
Clinton
On 12/20/05, Clinton
Begin <[EMAIL PROTECTED]>
wrote:
We can't use #, because it is the parameter syntax, and no, we won't
parse the SQL to figure out what is a result and what is a parameter. :-)
Cheers,
Clinton
On 12/20/05, Jozef
Hribik <
[EMAIL PROTECTED]> wrote:
Hi Clinton,
+1 abd I would like to have one more option ;-)
#COLUMN:KEY:TYPE#
<select id="elions.uw.selectInfoProductInsured"
resultClass="map">
SELECT #p.T01_NAME:name:String#, #p.T01_AGE:age:Integer#
FROM T01_PERSON p
</select>
Cheers
Jozef
Clinton Begin wrote:
>
> I would love to add inline result map support. :-)
>
> Unfortunately you and I are the minority. But that doesn't mean
we
> cannot do it. So, my question to you is: how would
you like to see
> the syntax?
>
> Here are some options:
>
> $NAME:VARCHAR$
> !NAME:VARCHAR!
> @NAME:VARCHAR@
> "NAME:VARCHAR"
> |NAME:VARCHAR| << I like the pipes, but does anyone know
of any
> potential issues with using it?
>
> In hindsight, I wish I had used @@ for inline parameters and ## for
> inline result maps (because it looks like a little row set!).
>
> Cheers,
> Clinton
>
>
>
> On 12/19/05, *Yusuf* <[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]
>> wrote:
>
> Dear All,
> I've been using ibatis for about 1 year now, and
i'm very
> satisfied with
> it!
> I wanted to ask if i can do this:
>
> <select id="
elions.uw.selectInfoProductInsured" resultClass="map">
> SELECT name, age, address, income
> FROM person
> </select>
>
> but I wanted the default datatype for NAME is
String, AGE is
> Integer, and INCOME is Double, not the default
BigDecimal..
> without specifying resultMaps or resultClasses
(because i have so
> many
> queries like this and it would be very verbose to
declare them one by
> one)
>
> I know we can declare something like this in
insert statements like
>
> <insert id="..">
> INSERT INTO person (name, age) VALUES
(#name:VARCHAR:-#,
> #age:NUMBER:0#)
> </insert>
>
> but can it be done in select statements to in
ibatis? for example like
> this maybe:
>
> <select
id="elions.uw.selectInfoProductInsured "
resultClass="map">
> SELECT name:String, age:Integer, address:String,
income:Double
> FROM person
> </select>
>
> Thank you...
>
>
|
