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
