You may find it has to do with the Locale / Number format of the windows settings of the server. Either SQL Server or the IIS Server.
In Win2k it's the 'Regional Settings' in control panel. Taks a look in there (compare to dev box). > -----Original Message----- > From: Parker, Kevin [mailto:[EMAIL PROTECTED] > Sent: Thursday, 27 March 2003 12:52 PM > To: CF-Talk > Subject: Weird SQL problem in CF > > > I have a weird problem with a pro bono job I'm doing and > hope someone has a > clue please. > > The app works fine on my dev box but when deployed to the > production box has > a strange problem with numerical fields. Its running CF4.5 > with SQL Server > 7. > > All numerical fields are being returned in the format 99,999.00 - > notwithstanding the problem, applying NumberFormat fixes it > but that doesn't > actually solve the problem as to why they are being returned this way. > Unfortunately applying NumberFormat to numbers used in > queries and lists > really screws with the application. The other interesting > effect is that if > the app is doing a query to a field with an ID greater than > 999 it falls > over because of the comma inserted into the number. For > example doing a > query to row 16123 return row 16 not row 16123, because the > query string > displays the row ID as 16,123.00. > > Any clues please. > > > ********** > Kevin Parker > Web Services Manager > WorkCover Corporation > > e: [EMAIL PROTECTED] > w: www.workcover.com > > p:+ 61 8 8233 2548 > f: +61 8 8233 2282 > m: 0418 806 166 > ********** > > > > ************************************************************** > ********** > This e-mail is intended for the use of the addressee only. It may > contain information that is protected by legislated confidentiality > and/or is legally privileged. If you are not the intended > recipient you > are prohibited from disseminating, distributing or copying > this e-mail. > > Any opinion expressed in this e-mail may not necessarily be > that of the > WorkCover Corporation of South Australia. Although precautions have > been taken, the sender cannot warrant that this e-mail or any files > transmitted with it are free of viruses or any other defect. > > If you have received this e-mail in error, please notify the sender > immediately by return e-mail and destroy the original e-mail and any > copies. > ************************************************************** > ********** > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
