Re: is there a better way of creating SQL queries from form objects ?

2005-05-10 Thread Sean Burlington
Erik Weber wrote: As far as the implementation goes, there is no reason to be scared of switches and loops. (But favor polymorphism/virtual functions over a giant loop.) However, you should get rid of all those concat operators and use StringBuffer.append instead. The performance will improve s

Re: is there a better way of creating SQL queries from form objects ?

2005-05-09 Thread Aladin Alaily
Hi Sean, iBatis works like a charm for what you're describing. You don't have to learn a new language. Just use SQLMaps and you're done. Good Luck. Aladin Sean Burlington wrote: Hi all, this is such a common problem that I'm sure there must be loads of advice on how to deal with it - I j

Re: is there a better way of creating SQL queries from form objects ?

2005-05-09 Thread Erik Weber
Erik Weber wrote: As far as the implementation goes, there is no reason to be scared of switches and loops. (But favor polymorphism/virtual functions over a giant loop.) Sorry, I meant over a giant switch, not loop! However, you should get rid of all those concat operators and use StringBuffer.

Re: is there a better way of creating SQL queries from form objects ?

2005-05-09 Thread Erik Weber
As far as the implementation goes, there is no reason to be scared of switches and loops. (But favor polymorphism/virtual functions over a giant loop.) However, you should get rid of all those concat operators and use StringBuffer.append instead. The performance will improve significantly. Eri

Re: is there a better way of creating SQL queries from form objects ?

2005-05-09 Thread Sean Burlington
Rick Reumann wrote: Look into using iBATIS http://www.ibatis.com. It's easy to use and will handle this kind of dynamic SQL very nicel (the PDF instruction manual is nice. Look at the SQL Maps documentatoin under Dynamic Mapped Statements.) that's a bigger change in coding than I was thinking o

Re: is there a better way of creating SQL queries from form objects ?

2005-05-09 Thread Rick Reumann
Look into using iBATIS http://www.ibatis.com. It's easy to use and will handle this kind of dynamic SQL very nicel (the PDF instruction manual is nice. Look at the SQL Maps documentatoin under Dynamic Mapped Statements.) Sean Burlington wrote the following on 5/9/2005 10:37 AM: Hi all, this