Rick,
I would recommend that you try it, since it really is quite trivial.
David's suggestion regarding the use of EntityWhereString should only be an
interim solution.
For starters, take a look at EntityOperator.java. You'll see that adding the "@@" operator is
quite trivial.
Jonathon
Richard Fleming wrote:
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
------------------------------------------------------------------------
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
