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ć 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 ć. > > 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/
