One oddity, however, with all of these queries - not of any importance, I'm just fascinated ...
I ran the query in SQLyog, copied the result to the clipboard using "Excel friendy values" for escape characters, and copied into Excel. No problem at all, looks lovely. But... one of my album titles is "True" and in the resulting Excel file it, and it alone, is capitalised and centred - "TRUE". I assume this is due to some part of the process assuming this is a boolean value instead of a string, though there's no obvious difference in the SQLyog results pane or in the Excel cell format... Curious. Ceejay -- ceejay ------------------------------------------------------------------------ ceejay's Profile: http://forums.slimdevices.com/member.php?userid=148 View this thread: http://forums.slimdevices.com/showthread.php?t=29282 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
