× 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.



Ok, so I wasn't going crazy. :)

I will try to remember to make a comment. But, here's a "theory" question.

would it be better for me to take each row from the result and build the
result set in node (as a whole, like exec() returns) and pass that entire
result set to my jade template, or loop in node and write out the data one
row at a time to my jade template that way.

Is there a "standard" for this type of processing?

Brad
www.bvstools.com

On Mon, Apr 4, 2016 at 9:35 AM, Aaron Bartell <aaronbartell@xxxxxxxxx>
wrote:

Not sure if there is reasoning from IBM behind that, but I agree, it would
be better (and more efficient) to get the entire result set. I would make
a comment on the bottom of that documentation page. IBM has been doing
good at collaborating with the community on developerWorks (which, in my
opinion, makes progress happen a lot faster than doing PMRs or DCRs).

Aaron Bartell
litmis.com - Services for open source on IBM i


On Mon, Apr 4, 2016 at 9:30 AM, Bradley Stone <bvstone@xxxxxxxxx> wrote:

If I'm reading the docs correctly:

1.3.15. execute

*Description:*

Runs a statement that was successfully prepared using *prepare*() once or
multiple times. The statement is processed with the current values of any
application variables that were bound to parameter markers by
*bindParam*().

*Syntax 1:*

execute()

*Syntax 2:*

execute(function *Callback*(*OutParamList*))

*Parameters **Callback*(*OutParamList*):

*Callback *is a callback function to process the output parameters of the
parameter markers. *OutParamList *is a list of the output parameters. It
is
in the java script array format.

*Comments:*

* If the statement also return a result set, user can issue the fetch()
function to retrieve the data row by row.


I believe This is saying that when using execute on a prepared statement
vs
exec on an SQL statement the rows NEEDS be processed one at a time.

bummer.. returning the entire result set made things so easy to throw
into
a jade template. :) Now I'm going to need to change how that's done. I
was wondering what was better practice, looping your result set records
in
the node.js or letting your template handle it...


--
This is the Web Enabling the IBM i (AS/400 and 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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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 copyright@midrange.com.

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