RE: Proof of concept - Simple inquiry -- WEB400

This is a multi-part message in MIME format.
--
FYI this program is attached to EVERY Order Acknowledgement that is sent
out from our system or about 2000 E-mails & Inquiry a day.  VERY fast,
considering all the Data is located on the back end system behind
another firewall and a T1 not an internal network...

        -----Original Message-----
        From: Andrew Borts
        Sent: Tue 11/27/2001 11:31 PM
        To: web400@midrange.com
        Cc:
        Subject: RE: [WEB400] Proof of concept - Simple inquiry



        This is a multi-part message in MIME format.
        --
        http://www.pbijc.com/wrk1/ecm208rp?ORNM=32433798&LSNM=BORTS.
Click on
        this - it's our order inquiry - VERY complex program - all RPG
using DDM
        files to get to our back end system.  We don't sort on column -
I
        recently re-wrote this using all Net.Data and a direct call to
RPG
        outputting a Net.Data table...

                -----Original Message-----
                From: rob@dekko.com
                Sent: Tue 11/27/2001 11:14 AM
                To: WEB400@midrange.com
                Cc:
                Subject: [WEB400] Proof of concept - Simple inquiry




                Does anyone out there have a simple inquiry program out
there
        which may be
                adaptable to our needs as a simple proof of concept?  I
am
        looking for a
                RPG-CGI program.

                What would really be slick would be the following;
Customer
        order inquiry,
                sortable by column.  For example

                Customer ##### - XXXXXXXXXXXXXXXXX

                Ord                    Qty        Qty      Requested
                 No  Lin Item     Cls  Ordered    Shipped    Date
                205   98 12020647 57    330.000   330.000 1999/03/01
                205   99 12020827 58    500.000   500.000 1999/03/01
                205  100 12052287 58    300.000   300.000 1999/03/01
                205  101 12059612 58    157.000   157.000 1999/03/01
                205  102 12065401 58    288.000   288.000 1999/03/01
                205  103 12066176 57   9912.000  9912.000 1999/03/01
                205  104 12089499 58     45.000    45.000 1999/03/01
                205  105 12089649 40   7500.000  7500.000 1999/03/01
                205  106 12103023 58    195.000   195.000 1999/03/01
                205  107 12124587 40   1404.000  1404.000 1999/03/01
                205  108 12146447 40  10602.000 10602.000 1999/03/01
                205  109 15300032 58    300.000   300.000 1999/03/01

                And if you click on any column it will sort it.


                Rob Berendt

                ==================
                "They that can give up essential liberty to obtain a
little
        temporary
                safety deserve neither liberty nor safety."
                Benjamin Franklin

                _______________________________________________
                This is the Web Enabling the AS400 / iSeries (WEB400)
mailing
        list
                To post a message email: WEB400@midrange.com
                To subscribe, unsubscribe, or change list options,
                visit: http://lists.midrange.com/cgi-bin/listinfo/web400
                or email: WEB400-request@midrange.com
                Before posting, please take a moment to review the
archives
                at http://archive.midrange.com/web400.



        --
        [ winmail.dat of type application/ms-tnef deleted ]
        _______________________________________________
        This is the Web Enabling the AS400 / iSeries (WEB400) mailing
list
        To post a message email: WEB400@midrange.com
        To subscribe, unsubscribe, or change list options,
        visit: http://lists.midrange.com/cgi-bin/listinfo/web400
        or email: WEB400-request@midrange.com
        Before posting, please take a moment to review the archives
        at http://archive.midrange.com/web400.



--
[ winmail.dat of type application/ms-tnef deleted ]