Ahhh. That's why I will always be on this list. I just needed to see
that.
I will try and let you know.
Thank you, Mr. Payne Teddy R. of USA. Most wonderful blessings.
Sincerely, the King of Nigerian.
_____________________
Derrick Peavy
derr...@derrickpeavy.com
404-786-5036
“Innovation distinguishes between a leader and a follower.” -Steve Jobs
_____________________
On Nov 25, 2009, at 9:19 AM, Teddy R. Payne wrote:
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 - teddyrpa...@gmail.com
On Tue, Nov 24, 2009 at 5:15 PM, Derrick Peavy <derr...@derrickpeavy.com
> 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
derr...@derrickpeavy.com
404-786-5036
“Innovation distinguishes between a leader and a follower.” -Steve
Jobs
_____________________