Totally blowing smoke here, but...
Do you need to cast the month() and year() as strings before you concatenate
them using the CONVERT function?
Jerry Johnson
Web Developer
Dolan Media Company
>>> [EMAIL PROTECTED] 02/15/05 05:30PM >>>
Sorry to put this here, but I am having trouble sending mail to the
cf-talk list.
This is probably a simple one, but anyway ...
I am trying to do this in MySQL:
SELECT blah1, blah2, CONCAT_WS('-',MONTH(OrderDate),YEAR(OrderDate)) AS
LegendDate
FROM table
I am expecting the results to be something along the lines of 2-2005, but am
actually getting the 'binary value' of '504550484853', which ColdFusion then
turns into '[EMAIL PROTECTED]'. I assume it has something to do with having
the
date functions inside the CONCAT() function. I tried DATE_FORMAT() and got
similar results. Is there another way to accomplish this?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:147302
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
