CF_QueryToText Output String
Excuse the vague subject, I didn't how to articulate it properly. My question is though I have been using the CF_QueryToText tag for some time now with great success, something now has come up that I cannot debug. The data has a character length of 15 in the table but the .csv output is appending a 0 to the end of the string making its LEN 16. Ex. in the field I have 123456712345678, but in the .csv file, that has changed to 1234567123456780. The records contain other fields with data varying in length and of Numeric, or Alpha/Numeric values and they translate accurately to the .csv but date lengths are below 15 characters. My db is SQL 2008, data type is nvarchar(50). Can anyone other any insight to the .csv is appending a 0 to the end of the string? ~| 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:356185 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Developer of http://www.hayneedle.com
Out of curiosity, what was the feature that you liked? Among other things they had a great system for product returns and, from what I've seen, a really good system for printing calculating shipping and printing shipping labels from UPS and FedEx. I'm sure there's an API for that, but it's well implemented. The site is also very smooth on the user-interface side. For me though, it's the shipping API interface I'm interested in. I have a similar need for my own site could probably speed up development time by working with someone whose already done that. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:356186 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Developer of http://www.hayneedle.com
I know UPS has an API for the labels - I built a wrapper for that once (amongst other parts of the UPS API). UPS has horrible documentation though. Ok, not horrible per se - just a horrible _package_ for their docs. Instead of a PDF, it is some fancy PDF package type thing that forces you to go into and out of books for every chapter or some such. Basically - a real pain in the rear for folks who want to quickly scan the docs. On Mon, Jul 15, 2013 at 10:29 AM, Robert Harrison rob...@austin-williams.com wrote: Out of curiosity, what was the feature that you liked? Among other things they had a great system for product returns and, from what I've seen, a really good system for printing calculating shipping and printing shipping labels from UPS and FedEx. I'm sure there's an API for that, but it's well implemented. The site is also very smooth on the user-interface side. For me though, it's the shipping API interface I'm interested in. I have a similar need for my own site could probably speed up development time by working with someone whose already done that. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:356187 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: scientific notation with significant figures
http://cflib.org/udf/scientificFormat On Fri, Jul 12, 2013 at 8:41 AM, Keith McGee kpmc...@frontiernet.netwrote: This didn't help, Thanks for the link though. ~| 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:356188 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF_QueryToText Output String
Perhaps try one of these...? http://cflib.org/udf/CSVFormat http://cflib.org/udf/QueryToCsv http://cflib.org/udf/QueryToCSV2 On Mon, Jul 15, 2013 at 8:14 AM, Charles Shafer malach...@indy.rr.comwrote: Excuse the vague subject, I didn't how to articulate it properly. My question is though I have been using the CF_QueryToText tag for some time now with great success, something now has come up that I cannot debug. The data has a character length of 15 in the table but the .csv output is appending a 0 to the end of the string making its LEN 16. Ex. in the field I have 123456712345678, but in the .csv file, that has changed to 1234567123456780. The records contain other fields with data varying in length and of Numeric, or Alpha/Numeric values and they translate accurately to the .csv but date lengths are below 15 characters. My db is SQL 2008, data type is nvarchar(50). Can anyone other any insight to the .csv is appending a 0 to the end of the string? ~| 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:356189 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: scientific notation with significant figures
Keith McGee kpmc...@frontiernet.net wrote: http://cflib.org/udf/scientificFormat On Fri, Jul 12, 2013 at 8:41 AM, Keith McGee kpmc...@frontiernet.netwrote: This didn't help, Thanks for the link though. The last time I had to deal with significant figures was in Pascal or Fortran. My approach was to write a procedure that would take the real value and the number of significant figures. I would multiply by 10*sigfigs, truncate, then create the string representing the decimal value. I would test the number of values from the decimal point and pad with 0s if needed. All I needed was the resulting text sort of like a Hollerith in Fortran. It has been 25+ years ago, but I think that's what I did. Note that real numbers are stored in logarithmic format so you need to pass strings after you convert. It gets complicated if you need to have the real value back so you can do math. I remember having code that would do basic math functions (+-*/) on two string values of numbers and calculate the proper number of sig figs when the two numbers had varying significant figures (i.e., 1.89325 * 10.1. That was freaky. There could be a Java package somewhere you could use, but I don't know of one. -- LinkedIn: http://www.linkedin.com/pub/roger-austin/8/a4/60 Twitter: http://twitter.com/RogerTheGeek Blog: http://RogerTheGeek.wordpress.com/ ~| 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:356190 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm