Jonathon, I'd be willing to try it. Thanks, if it can be added to the core, it'll be worth the effort.
Rick Jonathon -- Improov <[EMAIL PROTECTED]> wrote: Rick, Doesn't sound too hard to put @@ into EntityOperator. Would you like to try it? I can at most help by pointing out all the lines of codes that you need to fiddle with. Jonathon Richard Fleming wrote: > David, > > Thanks for the reply. I'd love to use the entity engine. But because the @@ > operator for tsearch's isn't part of the jdbc driver for postgres, I think > I'm stuck. Is there a way within the entity engine to create a custom sql > statement and then add it as an entity-condition tag or whatever? > > If not, I'll follow your other advice. > > Thanks again > Rick > > David E Jones wrote: > This is more of a question about JDBC and FTL, ie somewhat independent of > OFBiz. > > The freemarker.org site or searching on google might have some helpful tips > on using a ResultSet object with FTL. I'm not aware of anything, but haven't > looked. If you can't find anything there I'd recommend creating an > implementation of the Iterator or List interfaces to wrap the ResultSet > object, like we have with the EntityListIterator in OFBiz. > > You could also write some code in a bsh script or whatever to go through the > ResultSet and put the data in a List of Maps that is easy to traverse in FTL. > > Actually, what I would do is step back and review the business level > requirement and find an easier way to do the query so that you can use the > nice easy tools and patterns already established... > > -David > > > Richard Fleming wrote: >> Rodrigo, >> Thanks for the reply.. but I can't use the delegator object. I have to use a >> jdbc connection so that I can query the database with a non standard >> operator (@@). The delegator doesn't support calling this operator. My life >> would be much easier if it did. So I create a database connection using the >> sqlprocessor and return a java.sql.resultset which I add to the context. >> >> I'm reading through the Freemarker docs but it would help to see an example >> in ofbiz which utilizes a resultset. >> >> <#list rs1 as parts> >> >> >> >> Where rs1 is a java.sql.resultset object. >> >> Do you have any ideas? >> Rick >> >> Rick >> >> Rodrigo Souza wrote: User delegator to data layer. >> Not use in .ftl files. >> >> 2007/8/6, Richard Fleming : >>> Hello all- >>> >>> I've put together a bsh script that puts a java.sql.resultset into the >>> context. How do I create a list tag in my freemarker file to display the >>> resultset? >>> >>> Thanks >>> Rick >>> >>> >>> >> > > > > ------------------------------------------------------------------------ > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.476 / Virus Database: 269.11.8/940 - Release Date: 8/6/2007 4:53 > PM