Tony Weeg wrote: > <cfquery name="get1" datasource="acts"> > select line, id from seatBeltLaws where line like '%’%' > </cfquery> > > why can i put that same query in query analyzer, get 24 records that > have some of those freakin characters contained within, however when i > run it in a the above cf code, i get nothing?
You forgot to mention: - OS - OS locale - RDBMS - database encoding - driver - charset settings with your driver - template encoding - usage of setEncoding() - usage of cfprocessingdirective - usage of cfcontent All for both the process of inserting the data originaly and for what you are doing now. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
