Re: Node.js result set question - Trimming blanks

I am not sure you can call out to a Jade template multiple times. Or
rather, I've not done it that way so I can't speak to that approach.

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


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

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.

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