- From: Christopher.R.Ball <christopher.r.ball@gmail.com>
- Date: Sun, 28 Nov 2010 08:35:44 -0500
- To: "Christopher.R.Ball" <christopher.r.ball@gmail.com>
- CC: XProc Dev <xproc-dev@w3.org>
Received on Sunday, 28 November 2010 13:36:19 UTC
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