Hi all, can we use sql fragments as some sort of function? Is there a way to pass "parameters" to an sql fragment. My need is something like this (within one sql):
fragment1(parameter1) union fragment1(parameter2) Or probably there is another way to achieve the same thing in ibatis? My intention is to simplify the application codes while at the same time I do not want to create functions in the DBMS. Hope I made my self clear. TIA, Panji On Thu, Nov 5, 2009 at 9:23 PM, Michael McCurrey <mmccur...@gmail.com>wrote: > The exposed SqlCommandSet would definitely be a nice to have. However, I > do see a problem with the license and being able to just drop it in the > source for iBatis as its currently licensed. It could be wrapped as a > third-party dll and reference that was as we currently do with the Castle > dll's. But that would bring the number of DLL's up to 5 > DataMapper,Common,Castle.Core,Castle.DynamicProxy2,Rhino.Commons.Clr > > thoughts? > > > On Thu, Nov 5, 2009 at 2:05 AM, vinay.a <vinay_onm...@yahoo.com> wrote: > >> >> The link for 'SqlCommandSet.cs' has changed. See below: >> >> >> http://rhino-tools.svn.sourceforge.net/viewvc/rhino-tools/trunk/commons/Rhino.Commons/ToPublic/SqlCommandSet.cs >> >> >> Ron Grabowski wrote: >> > >> > Have you seen this? >> > >> > >> https://rhino-tools.svn.sourceforge.net/svnroot/rhino-tools/trunk/rhino-commons/Rhino.Commons/ToPublic/SqlCommandSet.cs >> > >> > >> > ----- Original Message ---- >> > From: Gilles Bayon <ibatis....@gmail.com> >> > To: user-cs@ibatis.apache.org >> > Sent: Monday, June 30, 2008 3:43:57 PM >> > Subject: Re: batch inserts >> > >> > In ADO.NET there is no simple way to do batch statement in a db >> provider >> > independent manner as in JBDC. >> > >> > For now, I haven't think of a good solution to implement batch support >> in >> > iBATIS.NET. >> > Perhaps other people have some ideas ? >> > >> > If you use SQL Server you do that with a store procedure and an XML in >> > parameter. >> > >> > -- >> > Cheers, >> > Gilles >> > >> > >> >> -- >> View this message in context: >> http://old.nabble.com/batch-inserts-tp18124219p26208634.html >> Sent from the iBATIS - User - Cs mailing list archive at Nabble.com. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org >> For additional commands, e-mail: user-cs-h...@ibatis.apache.org >> >> > > > -- > Michael J. McCurrey > Read with me at http://www.mccurrey.com > http://chaoticmindramblings.blogspot.com/ >
