Invalid XML Data - Affected by Apostrophe in Database Field Name (MS Access), PHP Platform

[aminmil]

Salam Sejahtera and Hi everyone,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

This is such brilliant application!

Currently, I am integrating this Fusion Chart Application with MS Access using PHP as my platform. I found out that, Invalid XML will happen when it pulls data from the database where the field name has an apostrophe like this: SS-1200/24'00. FYI, it will not be a problem if the apostrophe is removed but it would be a lot of work just to edit the field name. Appreciate if could provide solution for this issues.

Thank you very much.

Regards,

Muzammil

[Guest Madhumita]

Hello,

Welcome to the FusionCharts Forum.

Thank you for appreciating our product.

 

The apostrophe has to be encoded as ' .

I assume you are using your own PHP API. Thus to encode the apostrophe as ' you can take cues from the FusionCharts_Gen.PHP file in the function encodeSpecialChars($strValue).

 

Hope this helps.

[aminmil]

Hello,

 

 

 

Thank you Madhumita for your response,

 

 

 

I have tried to encode apostrophe as ' by manually editing it in the coding but still it doesn't work.

 

 

 

Interested to know on how to take that cues. Where do I get this FusionCharts_Gen.PHP and particularly the function encodeSpecialChars($strValue)

 

 

 

Regards,

 

Muzammil

Edited October 24, 2009 by Guest

[Guest Basundhara Ghosal]

Hi Muzammil,

Could you please try it using '%26apos;' in place of "'s"

Hope this helps.

[aminmil]

Hi Basundhara Ghosal,

 

 

 

Thank you very much,

 

 

 

That works perfectly.

 

 

 

Thanks again! Appreciate your information.

 

 

 

Muzammil

[Guest Rajroop]

Hey Muzammil,

 

 

 

You are most welcome!