Get Blogged by JoKi

"The only frontiers are in your mind"
22 | 07 | 2017
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

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


Spacer for layout formatting

Transfer of articles re-loaded

User Rating:☆☆☆☆☆ / 0
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