> I have a weird problem.. > > In my database (MS SQL Server) I have the valus 12,53131 in a > field of type float. > > When I retrieve the value using a query and output it, the > values is 12! > > I have tried running the SQL using the MS SQL Server > Management Studio and here I get the correct value of 12,53131. > > Can anyone shed some ligth on this please?!? (I am running CF7)
First, if you're running CF 7, you might want to either upgrade to 7.0.2, or install the newest DataDirect drivers available here: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_17883 Second, if that doesn't fix your problem, you might try an alternative SQL Server JDBC driver. My assumption is that you're using SQL Server 2005; Microsoft has their own JDBC driver that you might try: http://msdn.microsoft.com/data/ref/jdbc/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266695 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
