Hey All - Not sure if this was happening to anyone else. CFMX6.1 and mySQL 4.0.17
When doing stuff like: Select monthName(dateTime) as monthName from ThisTableHere the 'monthName' is being returned as a Binary String... which causes CFMX to throw a big wobbly stating 'Binary variables cannot be converted to string'. I can fix this by using a CONVERT(monthDate, CHAR) funtion, but I'm wondering if there is some sort of global fix for mySQL? Just to make my life easier? I.e. turn all binary strings into varchars, or something? Thanks in advance, Mark ------------------------------------------------------------------ [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [ www.safefrombees.com ] --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
