Using 4.1.3 beta (InnoDB) on XP, via ColdFusion MX
I have a table containing (among other things) a list of dates for soccer
matches to be played. In order to list them correctly, the SQL has been:
SELECT DISTINCT fixturedate,
MONTH(fixturedate) AS CalMonth
FROM Fixtures
ORDER BY fixturedate
which works fine, and I'm able to output the result of the SQL without
problem.
If that query is changed to:
SELECT DISTINCT fixturedate,
MONTH(fixturedate) AS CalMonth,
DATE_FORMAT(fixturedate, '%d a%') AS testing
FROM Fixtures
ORDER BY fixturedate
Coldfusion tells me that it can't convert a ByteArray into a string when
it tries to output #testing# from the query (the other two fields are
output with no error). However, outputting this query to a text file shows
the #testing# field as a string.
If the 'DISTINCT' is removed:
SELECT fixturedate,
MONTH(fixturedate) AS CalMonth,
DATE_FORMAT(fixturedate, '%d a%') AS testing
FROM Fixtures
ORDER BY fixturedate
Then the #testing# string outputs without a problem.
Is there something in the documentation I've missed, or is this a bug
(perhaps in CFMX)? Can't see why the DISTINCT clause should change a
string to a ByteArray....
Any help would be appreciated.
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
