BIGINT in scientific notation

["Mr R 101" <webforumsuser@xxxxxxxxxxxxxx>]

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