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
