You could just update your database field with the value of 0 where it is null, and from then on just have a default value of 0 for that field (if it's possible in Foxpro, I don't know). This will work if you can consider the values of 0 and null to be equal. I think it would save you a lot of changing code.
Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 7:21 AM To: CF-Talk Subject: Just to Report Bug in MX Just to let you know that <CFSet a = "0"> <cfoutput>#LSCurrencyFormat(a, "local")#</cfoutput> WORKS but <CFSet a = ""> <cfoutput>#LSCurrencyFormat(a, "local")#</cfoutput> Doesn' WORK. I am quering from foxpro DB and getting emply fields for loads of values. Now this bug is causing me to change atleast 300 files as I am migrating from CF5.0 to CFMX. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
