In the DB4 it is a "double" number field- when imported into SQL it changes to float. just like all the text fields become nvarchar and need changed to varchar. Thanks, j
-----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 9:16 AM To: CF-Talk Subject: RE: OT-Another quick question- float datatype Quoting Janine Jakim <[EMAIL PROTECTED]>: > > The data is generally an id of some sort- teacherid/etc. An integer (or at least an exact numeric) should be fine. Frankly, I am a bit surprised that they used an approximate numeric for an ID, which typically is something you use as PK/FK. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
