- 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