I'm running into an issue that's got me stumped. I have an application
that is storing IP addresses as unsigned 32 bit integers in a mysql db.
I need to pull this data from the db via Coldfusion (MX) so i've got my
select statement:
select distinct inet_ntoa(ip_src) as ipsource from acid_event limit 2;
Which returns:
+--------------+
| ipsource |
+--------------+
| 4.7.210.187 |
| 4.10.136.181 |
+--------------+
2 rows in set (0.09 sec)
inet_ntoa() is a native mysql function that converts the unsigned 32-bit
int into a 4-octet IP. My problem is that CF thinks the result is
spiting out binary output, exact error is:
rror Occurred While Processing Request
ByteArray objects cannot be converted to strings.
A cfdump of the query and error are at
http://console.syn-recon.net/includes/top10attackers.cfm
Anyone have any advice ?
Thanks,
Florian
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
