An application consists of Flex as front end, Coldfusion 9 as middle tier and MySQL 5 as the back end.
A MySQL table contains some fields which contain HTML formatting. So, if a field has value string "Test Record" it is stored as <TEXTFORMAT LEADING="2"><P ALIGN="LEFT"><FONT FACE="Arial" SIZE="12" COLOR="#0B333C" LETTERSPACING="0" KERNING="0">Test Record<FONT SIZE="8"></FONT></FONT></P></TEXTFORMAT> in the MySQL table Now, this field's value is being printed in a PDF document as <cfdocument format="pdf" filename="#report_filename_format#" orientation="landscape" overwrite="yes" marginbottom="0" marginleft="0" marginright="0" margintop="0" pagetype="legal"> <tr> <td width="20%" style="background-color:##CCCCCC; font-weight:bold; text-transform:uppercase; vertical-align:top;"> Value </td> <td width="80%">#printrecord.field_value#</td> </tr> Since, the field value is stored with HTML formatting, the space taken is more and there is no control about the printed text's font type and font size. 1. Is there any function in Coldfusion 9 which can convert the field's value to a regular text(without the HTML formatting) so that if "Test Record" would print the same regardless of whether it was stored as font size 10 or font size 30? 2. I am thinking of one way is to get the record being printed in a Flex application, use field.text property of a TextArea control(in Flex) to convert to regular text, then pass the converted value to Coldfusion for printing in the PDF document. Are there other better options? Any suggestions would be appreciated. ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------