Re: [DFW CFUG] Character set issues

Fri, 26 May 2006 14:15:36 -0700 

You just need to escape that # sign:

<cfset b = replace(url.a,"##","##")>


Run the following code in a test file to see what I mean:
<cfset a = "&##263;">
<cfoutput>
   #url.a#<br>
   <cfset b = replace(url.a,"##","##")>
   #b#
</cfoutput>
So if you did the cffile without the name for the query result and then did the replace on the cfhttp.filecontent, then you'd probably come up with something fairly useful and could then manually create your own query. 


****************************************************************
Ken Ferguson
214.636.6126
[EMAIL PROTECTED]

I'm currently in the market for any available project work.
Experience, knowledge and strong references I can
certainly provide.
****************************************************************



Colin Wilson wrote:

What we have happening is a server which is running php creates a string. I
read that string from the cold fusion server using cfhttp. I then clean up
the string to replace the line delimiters with carriage returns, and write
the file locally as a text file. 
One record we had was Nikola Livakovic with an accent on the c... For
reviewing the import I have it output the text file on the cfm page and I
get the accent showing fine. When I then have this code below read the text
file to try and import the records, I get it changing the Livakovic to
Livakovi&#263 and the # sign seems to cause it to suggest illegal string...
Do I need to match the character set of the text file / original php server
output so that it reads the content correctly?

 <cfhttp url="http://www.domain.com/admin/import_data/reg_import2.txt";
method="get" delimiter="," textqualifier="""" Name="reg_import_Query">
Thanks 
Colin


-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Ken Ferguson
Sent: May 26, 2006 12:26 PM
To: Dallas/Fort Worth ColdFusion User Group Mailing List
Subject: Re: [DFW CFUG] Character set issues

Import into what? What's the error? Are you getting a cf error from the #
sign when you're doing a cffile read or are you getting an error trying to
import it into your db? A little more detail on what's happening and I'm
sure we can help you track it down.

****************************************************************
Ken Ferguson
214.636.6126
[EMAIL PROTECTED]

I'm currently in the market for any available project work.
Experience, knowledge and strong references I can certainly provide.
****************************************************************



Colin Wilson wrote:
Sorry forgot to change the subject for this message... 
Colin

Hi,
We've been having trouble with a text registration import... The person has used special characters in their name - a c with the accent. When trying to import this comma separated text file, it's throwing an error when it comes to the &#263. 

Any suggestion on how to get past this?

Thanks in advance.

Colin Wilson


_______________________________________________
Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com 
  www.teksystems.com/


_______________________________________________
Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/ 





_______________________________________________
Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com 
  www.teksystems.com/


_______________________________________________
Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/ 





_______________________________________________
Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/

Reply via email to