Hello Sandra, You mentioned of a LA CFUG. Is this the Los Angeles CFUG? If so, GREAT. I was wondering if there was a user group here. I live in Monterey Park. Where is meeting held and when? Justme Kinley -----Original Message----- From: Sandra Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 06, 2000 4:31 PM To: CF-Talk Subject: RE: CF outputing SQL Server int field with decimal's? This came up in our LA CFUG meeting last night. Apparently the behavior in how CF sees a number was changed internally from 4.0 to 4.5.1. CF doesn't know the difference between a precision variable and an int. It just sees a number. Use NumberFormat() or Int to display correctly. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 10:27 AM To: CF-Talk Subject: CF outputing SQL Server int field with decimal's? I've successfully upsized an access 2000 db to SQL Server 6.5 using SQL Server 7.0 import export wizard, when I cfoutput the data or look at the table data through rds the integer fields are of the format: 1.00 2.00 2,345.00 instead of: 1 2 2345 But, when I query the db with the query tool in SQL Server 6.5 I get the correct output of: 1 2 2345 Any integer fields are like this now including index's and primary key's. When I run the following query: <cfquery name="editdb" datasource="holo_bills_sql" username="sa" password="22073207"> SELECT BillID,BillNumber FROM Bills WHERE SessionID = 2001 AND BillNumber = 4 </cfquery> <cfoutput>#editdb.RecordCount#<br></cfoutput> <cfoutput query="editdb"> #BillID# - #BillNumber#<br> #int(BillID)# - #int(BillNumber)#<br> </cfoutput> I get: 1 51.00 - 4.00 51 - 4 So this really screws things up. If I can't find a way to keep the integer fields whole number I'll have to change alot of code to int(BillNumber), etc. Anyone have any ideas what I did wrong or how I could fix what I've got. Thanks. Ric Smith h_o_l_o_g_r_a_p_h_i_c 103 Meridian St. Tallahassee, Florida 32301 www.holographic.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
