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

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 UTC