[ cf-dev ] OT: Mysql madness

[Alex Skinner]

Hi,   THought id see if anyone had had the same issue with mysql before i through the server out the window   I have a forum app which needs to work out on threads when the last post was to a particular thread   V easy no probs there then but Mysql or more likely cf (but i wanna blame mysql) is returning the aggregated field as binary :-) nice aye.   query is below   select max(messages.posted) as lastpost    from threads    join messages on threads.id=messages.threadidfk    where threads.id=12   Now it works fine querying mysql directly so yes it is something with cf or JDBC driver any ideas ?   Alex  --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.657 / Virus Database: 422 - Release Date: 13/04/2004