Sod. I was hoping for a better answer :oP
The annoying thing is - I installed 4.0.17 on my dev machine, and 3.23 is on the prod server. (Yes, I'm dumb.. i know) So CONVERT will break on the prod server :oP (it's a 4.0+ funtion) Trim didn't cut it... oh well.. guess I'll just have to convert the code before i upload it or something... Thanks anyway. Mark ------------------------------------------------------------------ [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [ www.safefrombees.com ] Quoting Mark Stanton <[EMAIL PROTECTED]>: > 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 > > > --- 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
