Hi,
I'm wondering how I could solve this problem without using a workaround:
I've got a huge table (about 60,000 entries), let's call it HUGETABLE. It
consists of two columns, HT_ID and NAME. I'm referencing to it via a foreign
key in another table.
I tried to use this command:
<db:dataLabel fieldName="HT_ID">
<db:queryData name="aQuery" query="select HT_ID, NAME from HUGETABLE" />
</db:dataLabel>
But this takes a very long time, sometimes even producing a
java.lang.OutOfMemoryException!
So I tried to specify the query:
<% String query = "select HT_ID, NAME from HUGETABLE where HT_ID=" +
currentRow_ACTUALTABLENAME.get("HT_ID"); %>
...
<db:queryData name="aQuery" query="<%= query %>" />
This works fine for the first entry, but the other ones are displayig their
HT_ID instead of the name. I guess, this query is only executed once, not
every cycle of db:body, so I cannot use this way either.
I then used a workaround, calling a class which progresses the query itself
using currentRow_..., this is working but not really the way I want it. Does
anyone see how this could be used using DbForms only?
Greetings
--
+++ NEU bei GMX und erstmalig in Deutschland: TÜV-geprüfter Virenschutz +++
100% Virenerkennung nach Wildlist. Infos: http://www.gmx.net/virenschutz
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
