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]
