Aren't you going to need to have a $ or whatever local currency symbol in front of it anyway? If you use <cfoutput>#LSCurrencyFormat(query.gs_price)#</cfoutput>
It will always format it in your local currency and add whatever 0's is needed, regardless of how it's stored in the database. In my understanding, this is the proper way to handle pricing display, and it's database independent, so if you ever changed databases, or the way the data is stored, you wouldn't have to change your code. Dave -----Original Message----- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Thursday, July 28, 2005 10:12 AM To: CF-Talk Subject: Entering a number becomes truncated howdy folks - hope your week is going fine. I have an Oracle database table with a column defined as such: gs_price NUMBER, and I enter it using: ..... SET gs_price = <cfqueryparam value="#Form.gs_price#" cfsqltype="CF_SQL_NUMERIC">, ..... Unfortunately, when I enter 2.50, it truncates the number to 2.5. It's a price so I need to keep it 2.50. I suppose that I could just format it correctly after I get it but I was hoping to have it correct in the DB. any thoughts? -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213097 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
