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

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

From: Christopher.R.Ball <christopher.r.ball@gmail.com>
Date: Sun, 28 Nov 2010 08:35:44 -0500
Message-ID: <4CF25AB0.304@gmail.com>
To: "Christopher.R.Ball" <christopher.r.ball@gmail.com>
CC: XProc Dev <xproc-dev@w3.org>
Realized I 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:36:19 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Sunday, 28 November 2010 13:36:21 GMT