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
Get the mailserver that powers this list at http://www.coolfusion.com
