though I think it's actually the JDBC drivers, not MySQL.
Cheers,
barneyb
> -----Original Message-----
> From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 22, 2003 4:41 PM
> To: CF-Talk
> Subject: MySQL Aggergate
>
> Okay, this is something funky. I have the following query:
>
> SELECT TL.T_id, MAX(dPosted) as LastDaySeen
> FROM TL INNER JOIN T ON
> TL.T_id = T.T_id
> AND T.lActive =0
> AND T.dInActive IS NULL
> GROUP BY TL.T_id
>
> This runs in a MySQL datasource and returns a query of
> records that need to
> be updated.
>
> However, when I try to loop through the above-motioned query and the
> LastDaySeen aggregate I get the following error:
>
> "ByteArray objects cannot be converted to strings"
>
> If I run the query in my phpMyAdmin I'm staring a group of well formed
> DateTime fields right in the face. A CFDump shows that CF is somehow
> reading the dates as strange arrays that it is saying are ByteArrays.
>
> HELP?
>
> Hatton
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
