W3C home > Mailing lists > Public > xproc-dev@w3.org > November 2010

Calabash - How to avoid Scientific Notation for large numbers . . ?

From: Christopher.R.Ball <christopher.r.ball@gmail.com>
Date: Sun, 28 Nov 2010 08:58:46 -0500
Message-ID: <4CF26016.9060003@gmail.com>
To: XProc Dev <xproc-dev@w3.org>

Realized I probably should have been more explicit.

I am using the number in the LIMIT function of MySQL as follows:

    Select id, comment from GroupTalk LIMIT 12000000, 5000

On 11/28/2010 12:26 AM, Christopher.R.Ball wrote:
> I am extracting content from a relational database (MySQL) for 
> analysis using xProc, but one little wrinkle I had not for seen is 
> Calabash seems to want to give me large numbers (over a million) using 
> scientific notation which is a pit of a problem when I am using those 
> numbers to manage the pagination from the relational database. In 
> other words, I am grabbing 5,000 rows at a time and slowly working my 
> way up through a table with 57 million rows, but calabash starts 
> giving me numbers such as "2.1E6" which the relational database can 
> not handle.
> I have created a working around by building the large numbers as 
> strings (e.g. concat('2100','000') but that adds some unpleasant 
> complexity.
> Grateful for any hints or insights,
> Christopher
Received on Sunday, 28 November 2010 13:59:22 UTC

This archive was generated by hypermail 2.3.1 : Tuesday, 6 January 2015 21:03:07 UTC