Not positive, but I'm not sure that CF supports the inet_ntoa() function
of mysql. I know that there is a UDF at cflib for handling the same type
of function (for insert, update, and select statements). This may be
better suited for your needs.
Cutter
pandemic wrote:
> Hi,
>
> 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]
