Re: Mapping SQL Result Sets to Browsers

["Alfredo Delgado" <adelgado@xxxxxxxxxxxxxxxxx>]

Nathan,

What I'd suggest is returning a SQL result set. In whatever language you're
using you'd go through a similar process of running a query against the DB
but you'd be calling a stored procedure instead.

Alfred

On Wed, Jul 2, 2008 at 1:22 PM, Nathan Andelin <nandelin@xxxxxxxxxxxx>
wrote:

> The discussion last month about validating and mapping HTML input
> elements to records helped me streamline some of my procedures.  Now I'm
> interested in streamlining my interface for writing SQL result sets to
> browsers.
>
> Actually, the recent discussion about generating PHP result sets from
> stored procedures triggered some of my thoughts on this matter, with my
> primary goal of coming up with an interface that's productive for RPG
> developers.
>
> With that in mind, are there methods that folks are using that you think
> are good, and would be willing to discuss, to help me improve my
> interface, regardless of whether you're using MS .Net, or PHP, or Java,
> or Net.Data, or CGI, or whatever?
>
> Say the application is simple as prompting the user to enter a name.
> Then generating a list of people having that name (or name prefix) from
> your database.
>
> Thanks,
>
> Nathan.
> --
> This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.