web stats
Row count from query - Page 2 - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #11  
Old 05-02-2018, 09:59 PM
aTom aTom is offline
OBX.3 Kenobi
 
Join Date: Feb 2016
Location: Lake Geneva Area
Posts: 115
aTom is on a distinguished road
Default

Hi,

There's nothing wrong in your piece of code, it worked for me.

As you did for 'sql' var I'd log the query result too:

Code:
logger.info(pagecount.getString(1));
The only things I can figure out is your 'totalpage' map variable being altered anywhere else in your transformer (and no, it's OK to do this in a transformer), or a scope issue with 'num_record' that you didn't explicitely declare here (var num_records=...).
__________________
Tom
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 03:34 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation