Yeah - lovely isn't it. Something to do with the JDBC driver I think (we had this problem moving CF5 apps to MX). Pretty much any date function or blob field will return binary data.
The only way around it is to run a string function of some sort over it (at the DB level). I think even trim() will work. Cheers Mark ------------------ Mark Stanton Technical Director Gruden Pty Ltd Tel: 9956 6388 Mob: 0410 458 201 Fax: 9956 8433 http://www.gruden.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
