Raymond Camden wrote: > > <cfset form_num = form["num_#thisID#"]> > > Then pass #form_num# in the sql. To me, this is preferable to using > evaluate. > > Anyway, I am pretty sure this was fixed in MX.
With unicode it actually gets more fun on CF MX (even though this is not Evaluate() related). Depending on drivers and what is in the form unicode will start doing strange things. Using MS SQL Server I have seen that insertion of the string "유니코드에 대해" will result in unbalanced single quotes. Must have something to do with the Unicode conversion, because there is no single quote in that string. I haven't been able to reproduce this at will yet, but if you want to test this and you don't have a UTF-8 capable email client, you can get the string at http://tessaban.tei.or.th/unicode/ (one of Paul Hastings unicode pages, look for the Korean). Using cfqueryparam appears to have become a whole lot more important with CF MX. Jochem ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
