Query list problem

indie_life · **Joined:** Wed May 02, 2007 6:37 am **Posts:** 6

Hi All,

I am haing a few problems with a basic query and printing a list to freemarker.

Code:

SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
    session =sessionFactory.openSession();  

        String SQL_QUERY = "from T1 AS t1, T2 AS t2 where t1.xxx='value' and t2.yyy='value'";

        Query query = session.createQuery(SQL_QUERY);
        result = query.list();

This result could be more than one. I need to print this using freemaker

Code:

<table ><tr>>DEMO</th>
      <#list result as r>
<tr><td>${r.column}<#if r_has_next></#if>
      </#list>
</table>

However, it refused to print the entry. Any suggestions?

Thanks

adamgibbons · **Joined:** Sat Apr 21, 2007 11:01 pm **Posts:** 144

https://sourceforge.net/forum/forum.php?forum_id=2346