Ron Grabowski wrote:
Huy, could you give an example additional functionality that another
templating engine would provide? Someone (Brandon?) asked a question a
few weeks ago about what other dynamic sql tags people would like to
see. I don't think anyone ever responded. I couldn't think of any
Subject: Re: [HELP] I can't not type sign in my sqlmap xml file
Ron Grabowski wrote:
Huy, could you give an example additional functionality that another
templating engine would provide? Someone (Brandon?) asked a question a
few weeks ago about what other dynamic sql tags people would like to
see. I
mei 2005 13:03
To: ibatis-user-java@incubator.apache.org
Subject: Re: [HELP] I can't not type sign in my sqlmap xml file
Ron Grabowski wrote:
Huy, could you give an example additional functionality that another
templating engine would provide? Someone (Brandon?) asked a question a
few weeks
Brandon Goodin wrote:
freemarker and velocity macros can create the same tags
The point is simply this... mixing semantics looks like hell.
I can understand this. I guess being an end user of such a simple yet
effective tool like sqlmap, I keep wishing for things to become even
easier
Nothing you said was menacing at all. I truly look forward to folks
innovating against ibatis. I hope that as we progress into the future
that ibatis will become more amiable to personal taste.
Brandon
On 5/25/05, Huy [EMAIL PROTECTED] wrote:
Brandon Goodin wrote:
freemarker and velocity
Huy, could you give an example additional functionality that another
templating engine would provide? Someone (Brandon?) asked a question a
few weeks ago about what other dynamic sql tags people would like to
see. I don't think anyone ever responded. I couldn't think of any
additional tags myself.
A while back, we had discussed the possiblility of pluggable scripting
engines. Of course, XML based dyna SQL would always be
enabled, but we could allow for 3rd party parsing of the resulting
SQL. I don't think it would be hard (the biggest problem might be
the conflict of certain key characters
Brandon Goodin wrote:
I don't plan on promoting any templating languages. It offloads the
burden to another layer. The dyanmic conditionals would get out of
hand. At that point it would be far easier to handle things in java.
The heirarchal nature of xml is of great importance to dynamic sql.
I guess it's always been a bit of a merry go round.
This may be true in cases where folks allow thing to get out of hand.
IBatis has maintained a very focused approach. There has not been a
real need to introduce a full blown templating language. Cuz if your
requirements get that complex... do it
Clinton Begin wrote:
I agree with Brandon. There are definite improvements we need to make
to iBATIS dynamic SQL, but that does NOT include building a full
templating language. The power of iBATIS dynamic SQL is the fact that
it is VERY specific to SQL. Using iBATIS dynamic SQL, you can
freemarker and velocity macros can create the same tags
The point is simply this... mixing semantics looks like hell. When you
start mixing xml with velocity for no good reason your lt; becomes a
minor blip on the radar of messy. The other reason is that you
introduce the FULL ability of velocity
Brandon Goodin wrote:
This is just plain funny. Can you tell that we love the easy questions?
Brandon
On 5/19/05, Ron Grabowski [EMAIL PROTECTED] wrote:
You can use:
lt;
I find it funny that lt; and gt; are acceptable solutions (even though
it works). I love sqlmap but I hate xml ! I
I don't plan on promoting any templating languages. It offloads the
burden to another layer. The dyanmic conditionals would get out of
hand. At that point it would be far easier to handle things in java.
The heirarchal nature of xml is of great importance to dynamic sql.
So, i still see it as
Use lt;
Mansour
J
From: Pham Anh Tuan
[mailto:[EMAIL PROTECTED]
Sent: Thursday, May 19, 2005 5:06
AM
To:
ibatis-user-java@incubator.apache.org
Subject: [HELP] I can't not type
sign in my sqlmap xml file
Hi,
I can't not type sign in sql definition xml
Hi,
I can't not type sign in sql definition xml
file, I don't know why, plz help me solve this problem :(
select id="getNOFBidding" resultClass="int" parameterClass="string"
select COUNT(distinct ITEMID)
from SALE
where SALESTATUS = 0 and MAXPRICE = 1
and TO_DAYS(NOW()) -
#
]]
/select
From: Pham Anh Tuan
[mailto:[EMAIL PROTECTED]
Sent: Thursday, May 19, 2005 5:06
AM
To:
ibatis-user-java@incubator.apache.org
Subject: [HELP] I can't not type
sign in my sqlmap xml file
Hi,
I can't not type sign in sql definition xml file, I
don't know why, plz
You can use:
lt;
Or enclose the text within CDATA:
select id=getNOFBidding resultClass=int parameterClass=string
![CDATA[
SELECT * FROM Sale WHERE TO_DAYS(NOW()) - TO_DAYS(SALEDATE) = 15
]]
/select
--- Pham Anh Tuan [EMAIL PROTECTED] wrote:
Hi,
I can't not type sign in sql definition
You have two options...
1) Substitute your with their entity counterparts lt; and gt;
Ex.
select id=getNOFBidding resultClass=int parameterClass=string
select COUNT(distinct ITEMID)
from SALE
where SALESTATUS = 0 and MAXPRICE = 1
and TO_DAYS(NOW()) - TO_DAYS(SALEDATE)
lt;= 15 and
use the entity reference lt; instead
From: Pham Anh Tuan [EMAIL PROTECTED]
Reply-To: ibatis-user-java@incubator.apache.org
To: ibatis-user-java@incubator.apache.org
Subject: [HELP] I can't not type sign in my sqlmap xml file
Date: Thu, 19 May 2005 16:06:08 +0700
Hi,
I can't not type sign
This is just plain funny. Can you tell that we love the easy questions?
Brandon
On 5/19/05, Ron Grabowski [EMAIL PROTECTED] wrote:
You can use:
lt;
Or enclose the text within CDATA:
select id=getNOFBidding resultClass=int parameterClass=string
