Which would be a much better solution since changing the datatype to smallint makes it extremely unlikely that you'll be able to re-use your code or db structure for any future project. Not many stores would be satisfied without the ability to have both dollars and cents defined in their price structure. (Goes back to coding for exceptions rather than for rules as discussed in a recent thread about beginner mistakes.)
-----Original Message----- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 02, 2005 4:14 AM To: CF-Talk Subject: RE: formattting my sell price I believe you could also have used SELECT FLOOR(price) AS price FROM Table. - Calvin -----Original Message----- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 7:24 PM To: CF-Talk Subject: Re: formattting my sell price I ended up changing the field to smallint. Then I just output with no dollarformat. Thanks for your help, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192760 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
