RE: NumberFormat UGH
sounds like the problem is with the DB you are using. Not sure how formatting the number with CF once you have pulled it from the db would help. What DB is it you are using? will -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: 19 April 2002 20:54 To: CF-Talk Subject: RE: NumberFormat UGH Will that work for Income Taxes too??? -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 12:48 PM To: CF-Talk Subject: RE: NumberFormat UGH Place curser on your NumberFormat and push the F1 key. All answers shall be revealed. :) -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 2:37 PM To: CF-Talk Subject: NumberFormat UGH I have searched hi and low for some explination, but am at a loss. I have a column in the db: weight, it is a float Values can range beyond 123445.23223 and .03322323 Is there a way to use numberformat so you can show these as they are... when I stick .03322323 into the database, it comes out 3.32232299E-2 Can't use decimalformat, need the multiple decimals ... numberformat either padds too many spaces or doesn't give me enough.. Anyone have any good recommendations for formating variable sized numbers with decimals? Thank Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: NumberFormat UGH
Place curser on your NumberFormat and push the F1 key. All answers shall be revealed. :) -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 2:37 PM To: CF-Talk Subject: NumberFormat UGH I have searched hi and low for some explination, but am at a loss. I have a column in the db: weight, it is a float Values can range beyond 123445.23223 and .03322323 Is there a way to use numberformat so you can show these as they are... when I stick .03322323 into the database, it comes out 3.32232299E-2 Can't use decimalformat, need the multiple decimals ... numberformat either padds too many spaces or doesn't give me enough.. Anyone have any good recommendations for formating variable sized numbers with decimals? Thank Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: NumberFormat UGH
Just kidding I'm at a loss. There may be a UDF at http://www.cflib.org that can help. -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 2:48 PM To: CF-Talk Subject: RE: NumberFormat UGH Place curser on your NumberFormat and push the F1 key. All answers shall be revealed. :) -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 2:37 PM To: CF-Talk Subject: NumberFormat UGH I have searched hi and low for some explination, but am at a loss. I have a column in the db: weight, it is a float Values can range beyond 123445.23223 and .03322323 Is there a way to use numberformat so you can show these as they are... when I stick .03322323 into the database, it comes out 3.32232299E-2 Can't use decimalformat, need the multiple decimals ... numberformat either padds too many spaces or doesn't give me enough.. Anyone have any good recommendations for formating variable sized numbers with decimals? Thank Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: NumberFormat UGH
Will that work for Income Taxes too??? -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 12:48 PM To: CF-Talk Subject: RE: NumberFormat UGH Place curser on your NumberFormat and push the F1 key. All answers shall be revealed. :) -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 2:37 PM To: CF-Talk Subject: NumberFormat UGH I have searched hi and low for some explination, but am at a loss. I have a column in the db: weight, it is a float Values can range beyond 123445.23223 and .03322323 Is there a way to use numberformat so you can show these as they are... when I stick .03322323 into the database, it comes out 3.32232299E-2 Can't use decimalformat, need the multiple decimals ... numberformat either padds too many spaces or doesn't give me enough.. Anyone have any good recommendations for formating variable sized numbers with decimals? Thank Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: NumberFormat UGH
Been there done that, but I am either not too smart, or there is no way around either having spaces or numbers deleted Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder Place curser on your NumberFormat and push the F1 key. All answers shall be revealed. :) -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 2:37 PM To: CF-Talk Subject: NumberFormat UGH I have searched hi and low for some explination, but am at a loss. I have a column in the db: weight, it is a float Values can range beyond 123445.23223 and .03322323 Is there a way to use numberformat so you can show these as they are... when I stick .03322323 into the database, it comes out 3.32232299E-2 Can't use decimalformat, need the multiple decimals ... numberformat either padds too many spaces or doesn't give me enough.. Anyone have any good recommendations for formating variable sized numbers with decimals? Thank Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: NumberFormat UGH
Not if you use notepad... Howie - Original Message - From: Justin Hansen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 19, 2002 3:47 PM Subject: RE: NumberFormat UGH Place curser on your NumberFormat and push the F1 key. All answers shall be revealed. :) -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 2:37 PM To: CF-Talk Subject: NumberFormat UGH I have searched hi and low for some explination, but am at a loss. I have a column in the db: weight, it is a float Values can range beyond 123445.23223 and .03322323 Is there a way to use numberformat so you can show these as they are... when I stick .03322323 into the database, it comes out 3.32232299E-2 Can't use decimalformat, need the multiple decimals ... numberformat either padds too many spaces or doesn't give me enough.. Anyone have any good recommendations for formating variable sized numbers with decimals? Thank Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: NumberFormat UGH
Try #LSParseNumber()# Success is a journey, not a destination!! Doug Brown - Original Message - From: Howie Hamlin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 19, 2002 1:04 PM Subject: Re: NumberFormat UGH Not if you use notepad... Howie - Original Message - From: Justin Hansen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 19, 2002 3:47 PM Subject: RE: NumberFormat UGH Place curser on your NumberFormat and push the F1 key. All answers shall be revealed. :) -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 2:37 PM To: CF-Talk Subject: NumberFormat UGH I have searched hi and low for some explination, but am at a loss. I have a column in the db: weight, it is a float Values can range beyond 123445.23223 and .03322323 Is there a way to use numberformat so you can show these as they are... when I stick .03322323 into the database, it comes out 3.32232299E-2 Can't use decimalformat, need the multiple decimals ... numberformat either padds too many spaces or doesn't give me enough.. Anyone have any good recommendations for formating variable sized numbers with decimals? Thank Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
