× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Unfortunetly, you are speaking greek to me. EGL Generates java code. It also
uses t400.jar if that sheds any light on whats going on behind the scenes. I
believe its all java based.

With Egl, you can basically load a datatable with 1 line of code:

Get countrytable;

This would run an sql which you can include if you wish:
Get countrytable with
#sql{
select
countryname, countrycode
from QS36F.country file
order by countryname
};

You can load a table record by record, but this is the fastest method.

So, since I am loading the country table all at once (get countrytable),
paging would not be an option. I can work in paging, but would really love
to be able to SFLRCDNBR a load-all-at-once datatable.


-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Aaron Bartell
Sent: Thursday, December 13, 2007 5:37 PM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] JSF/EGL datatable positioning question


I meant to say SQL paging which would be required for most dataTable's in a
frequently used application. What you are describing simply loads the
entire result set into memory and scrolls through the Java Collection. You
will outgrow this fast so I would recommend getting it working with SQL
paging sooner than later. My processes outgrew it when there were around
half a million records (note this was on a souped up Wintel Dell rackmount
server).

I could show you how I do it with Apache MyFaces and Hibernate, but I don't
know if that would really help you. What is EGL using for data access under
the covers? Does it have some sort of ORM solution (I believe IBM's first
JSF incantations used Web Data Objects or WDO).

If what I am saying doesn't make sense then I can try to put together a
sampling using what I have.

HTH,
Aaron Bartell
http://mowyourlawn.com


-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of tim
Sent: Thursday, December 13, 2007 4:17 PM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] JSF/EGL datatable positioning question

Paging out of box. Yes, You can specify height of table and it will add
scroll bar controls as needed. You can also set up how many records to be
displayed per page and it will control the page forward/back functionality.

I guess what I am doing in RPG talk would be loading the entire subfile at
once. And im wondering if there is a SFLRCDNBR equivalent in JSF/EGL.

Im new to doing EGL so not sure all the terms.

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Aaron Bartell
Sent: Thursday, December 13, 2007 4:45 PM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] JSF/EGL datatable positioning question

The way I do this with JSF is have the backing bean be session scoped and
then store the rrn of the SQL result set to start at each time the listing
is redisplayed. Even if they navigate off the page and back again they will
be returned to the exact page they were looking at.

Does EGL come with paging out of the box?

HTH,
Aaron Bartell
http://mowyourlawn.com





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.