BIGINT in scientific notation

Hi,

New here and new to CF8. I’m using MySQL 5.0.51b with the
latest JDBC connector and am getting unsigned BIGINT columns larger
than 10^12 back in scientific notation instead of a whole number.
Here’s an example:

<cfquery name=”get_bigint” datasource=”ds”>

select cuid,convert(cuid,signed) as c_cuid

from ctable

where id=17

</cfquery>

<cfdump var=”#get_bigint#”>

cuid is an unsigned BIGINT in ctable. In the CF dump, cuid is
displayed in scientific notation and c_cuid is displayed as a whole
number. If I try to use cuid, say as a URL parameter, it also ends
up in scientific notation, which is obviously undesirable. Is there
a configuration setting I need to change somewhere or is the CF /
JDBC way to deal with this to use CAST / CONVERT on BIGINT columns
to ensure they stay in whole number format?

Thanks

Related posts:

1. Unsigned Bigint in CF8
2. E4X dot notation
3. Notation difference question
4. Notation difference question
5. Weird Value Returned to CF from SQL Stored Proc

Related posts brought to you by Yet Another Related Posts Plugin.