Re: CFDocument PDF text duplication
Hello CF-Talk, I've been a long-time reader of your mailing list and this is my first post :) I've been working with PDF generation (CF 8.0.1 / Windows Linux) and have gotten most of the known kinks fixed but there's still one problem that I can't get around: Sometimes when (bold?) text that is supposed to wrap to the next line get duplicated (is shown twice)... once on the first line outside the margins of the pdf and once again on the next line. crude oil prices, meanwhile, rebounded gets repeated. see: https://www.advantagedata.com/page_toPDF.gif I haven't found the source, but usually unbolding the problematic string or the entire paragraph fixes this duplicating bug. Adjusting the scale from 100 to 99.6 sometimes helps too. Has anyone else seen this behavior? My CFDOCUMENT margins are set to zero, and the paragraph content is in a div. I'd appreciate any feedback. Thanks, Minh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354080 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFDocument PDF text duplication
I am also able to reproduce the same issue. I did try to generate the PDF using cfpdf, cfcontent etc but that did not help. Using the wrap function and trying to generate the PDF directly from itext also failed. Was any one able to solve this issue ? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Getting Record Count
If I'm running a query on a database and limit the records returned to 10, what's the best way to get the record count for the entire dataset if everything was return and not just the first 10 records? I can re-rerun the query without the 10-record limit, but that seems like a ridiculous approach, just to get the record count. Suggestions! Thanks, Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354082 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Getting Record Count
Do a first quesrt using sql count On Jan 26, 2013 12:41 PM, Rick Faircloth r...@whitestonemedia.com wrote: If I'm running a query on a database and limit the records returned to 10, what's the best way to get the record count for the entire dataset if everything was return and not just the first 10 records? I can re-rerun the query without the 10-record limit, but that seems like a ridiculous approach, just to get the record count. Suggestions! Thanks, Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354083 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Getting Record Count
Something like this perhaps? SELECThelp_topic_id , (SELECT count(help_topic_id) FROM mysql.help_relation ) as IDCount,help_keyword_id FROM mysql.help_relation LIMIT 10; On Sat, Jan 26, 2013 at 12:41 PM, Rick Faircloth r...@whitestonemedia.comwrote: If I'm running a query on a database and limit the records returned to 10, what's the best way to get the record count for the entire dataset if everything was return and not just the first 10 records? I can re-rerun the query without the 10-record limit, but that seems like a ridiculous approach, just to get the record count. Suggestions! Thanks, Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Getting Record Count
That worked! Learn something new every day! Thanks, Gerald and Brian for the tips! Rick -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Saturday, January 26, 2013 5:45 PM To: cf-talk Subject: Re: Getting Record Count Something like this perhaps? SELECThelp_topic_id , (SELECT count(help_topic_id) FROM mysql.help_relation ) as IDCount,help_keyword_id FROM mysql.help_relation LIMIT 10; On Sat, Jan 26, 2013 at 12:41 PM, Rick Faircloth r...@whitestonemedia.comwrote: If I'm running a query on a database and limit the records returned to 10, what's the best way to get the record count for the entire dataset if everything was return and not just the first 10 records? I can re-rerun the query without the 10-record limit, but that seems like a ridiculous approach, just to get the record count. Suggestions! Thanks, Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354085 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm