Get Blogged by JoKi

"The only frontiers are in your mind"
23 | 04 | 2017
Navigation
Syndication
Latest Tweets

Most Read Articles
Article Time Line
About me
Family guy, geek, entrepreneur, software craftsman: Visual FoxPro, C#, SQL Server, MySQL, Linux consultant, conference speaker

Certificates & Awards

Microsoft Certified Professional

Microsoft Specialist - Programming in HTML5 with JavaScript and CSS3 Specialist

Get in touch

Sharing is caring

Recent books


Sponsoring
If you like the information on these pages, your support is highly appreciated.
Thank you very much!
Affiliates

 

Spacer for layout formatting

Transfer of articles re-loaded

User Rating:☆☆☆☆☆ / 0
PoorBest 
General 24 February 2008 - 
Thanks to my reader's feedback I modified the conversion routine of the article transfer from the MySQL database to XML. As the content of this blog is now UTF-8 encoded my article content has to fullfil this as well. So, using VFP this takes just another function call - Strconv() - with the right parameters.

What I did is to change two lines of code in the XML template block for the output:
<Content><<Strtran(Strconv(Strconv(Alltrim(p_summary),1),9), Chr(13)+Chr(10), "&"+"lt;br"+"&"+"gt;"+Chr(13)+Chr(10))>></Content><Title><<Strconv(Strconv(Alltrim(p_title),1),9)>></Title>
That's all. Strconv() converts characters into different encodings. You might have a look at the documentation in VFP's help file.


Sincerely, JoKi


blog comments powered by Disqus
 
Spacer for layout formatting