#Evaluate(’)# if i put that in the middle of the sql code in the cfquery tag...i get this error....are these unicode values for those characters?
"\u00e2\u20ac\u2122," on line 73, column 71, is not a valid identifer name. ?? searching ?? tw -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 8:57 PM To: CF-Talk Subject: RE: sql hell XP - OS USA My House - OS locale SQL Server 2000 - RDBMS No Idea? - database encoding CFMX ODBC - driver No Idea? - charset settings with your driver CFMX? - template encoding None. - usage of setEncoding() None. - usage of cfprocessingdirective None. - usage of cfcontent i cut and paste from a word doc to a text file. >From the text file, i cut and paste into cfmx page, form textareas and inserted into database Text datatype fields. on first query i noticed every instance of the words "driver's license" really looked like .... A driver or passenger who fails to wear a safety belt shall pay a $25 fine. Court fees may not be applied to this provision. A violation of this provision may not appear on a driver’s license, may not be reported to an insurance company, and no points m.... obviously thats wrong. its supps to read driver's license. anyway, if i run this query in query analyzer <cfquery name="get1" datasource="acts"> select line, id from seatBeltLaws where line like '%’%' </cfquery> i get 24 matching records, of which i would love to loop through and use the udf Demoronize() from cflib.org to remove the crap, and insert 's HELP!!!!!! thanks, tony -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 8:49 PM To: CF-Talk Subject: Re: sql hell 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
