Derrick,
Data truncation usually brings to mind java data conversion. Have you tried
casting the results of the crc32 function?:
CAST(crc32('127.0.0.1') AS int)
Alternatively, what version of ColdFusion are you using? I have looked at
the MySQL driver in CF8 recently. In the past, I had good success using
JConnector to replace the JDBC MySQL default driver that came with CF.
Here is the 4.1 manual referene to JConnector:
http://dev.mysql.com/doc/refman/4.1/en/connector-j.html
And here is the JDBC driver configurations instructions:
http://kb2.adobe.com/cps/025/6ef0253.html
If you are already using JConnector, ignore the recommendation. =)
Teddy R. Payne, ACCFD
Google Talk - [email protected]
On Tue, Nov 24, 2009 at 5:15 PM, Derrick Peavy <[email protected]>wrote:
> Trying to remove a PHP script from a cold fusion site by replacing it with
> a simple CF query.
>
> Current PHP file puts a crc32 value into an int(10) field in MySQL 4.1.13
>
> Trying to do this with CF, nothing fancy. Basic SQL statement.
>
> Example:
>
> INSERT INTO exampleTable
> (domain_checksum)
> VALUES (crc32('127.0.0.1'))
>
> I then get this error: *Data truncation: Out of range value adjusted for
> column 'domain_checksum' at row 1*
>
> But the data looks correct. For example, the value for 127.0.0.1 is
> generated as 3619153832
>
> If I try to insert the values directly into MySQL, no problem. But using a
> standard CFQUERY produces an error.
> *
> _____________________*
> *Derrick Peavy*
> [email protected]
> 404-786-5036
> *
> *
> *“Innovation distinguishes between a leader and a follower.” -Steve Jobs*
> *_____________________*
>
>
