RE: MSSQL Decimal Field
10/4 David Manriquez Desarrollador [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 18 de Abril de 2005 11:52 Para: CF-Talk Asunto: RE: MSSQL Decimal Field What is its length/precision in the DB? -Original Message- From: David Manriquez [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 16:35 To: CF-Talk Subject: MSSQL Decimal Field Hi there. i have a little problem here with storing decimals in MSSQL.. i need to store a decimal number with 1 to 4 decimals but when i return the data i need to see the exact numbers of decimals what i save i mean.. if i save 1.14 i spect 1.14 from the DB not 1.1400 any tips?... i was testing with decimal , float and reals ~| 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:203294 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
MSSQL Decimal Field
Hi there. i have a little problem here with storing decimals in MSSQL.. i need to store a decimal number with 1 to 4 decimals but when i return the data i need to see the exact numbers of decimals what i save i mean.. if i save 1.14 i spect 1.14 from the DB not 1.1400 any tips?... i was testing with decimal , float and reals ~| 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:203269 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
RE: MSSQL Decimal Field
What is its length/precision in the DB? -Original Message- From: David Manriquez [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 16:35 To: CF-Talk Subject: MSSQL Decimal Field Hi there. i have a little problem here with storing decimals in MSSQL.. i need to store a decimal number with 1 to 4 decimals but when i return the data i need to see the exact numbers of decimals what i save i mean.. if i save 1.14 i spect 1.14 from the DB not 1.1400 any tips?... i was testing with decimal , float and reals ~| 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:203283 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54