Check the scale and precision?

CC


                                                                                       
                            
                    "Les Mizzell"                                                      
                            
                    <lesmizz             To:     CF-Talk <[EMAIL PROTECTED]>   
                            
                    @bellsouth.ne        cc:                                           
                            
                    t>                   Subject:     SQL Database "Decimal" problem   
                            
                                                                                       
                            
                    12/05/02                                                           
                            
                    12:20 PM                                                           
                            
                    Please                                                             
                            
                    respond to                                                         
                            
                    cf-talk                                                            
                            
                                                                                       
                            
                                                                                       
                            




Hi,

1. Field data type is defined as "Decimal"
2. Insert/Update from form "1.234"
3. Look in database - value written is "1".

It's getting truncated

Suggestions?


Thanks...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Reply via email to