Steve and everyone else, Thanks for the CFIF suggestion, this will work, I was attacking the problem from a different direction.
Kent ----- Original Message ----- From: "Steve Oliver" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 21, 2002 7:35 AM Subject: RE: Receive CFQUERY results in dollar format I'm assuming you want nothing returned then if the value is 0? Why not just use a cfif? <cfoutput query="cat"> <cfif cat.price_a1 GT 0> #DollarFormat(cat.PRICE_A1)# </cfif> <cfif cat.price_a2 GT 0> #DollarFormat(cat.PRICE_A2)# </cfif> </cfoutput> ______________________ steve oliver cresco technologies, inc. http://www.crescotech.com -----Original Message----- From: Kent A. Orso [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 7:25 AM To: CF-Talk Subject: Receive CFQUERY results in dollar format I'm trying to write a CFQUERY statement that will take data from a Microsoft Access 2000 database and return the numeric value as dollar value. I have tried using DOLLARFORMAT in the CFOUTPUT statement but I have six different pricing columns based on the product size and the empty columns/rows show $0.00 if the DOLLARFORMAT command is used. The Microsoft Access database columns are formatted as follows: FIELD SIZE: Long Integer FORMAT: Fixed Decimal Places: 2 This is what I have thus far for the CFQUERY: <CFQUERY DATASOURCE="cat" NAME="Products"> SELECT SPECIES, DESCRIPTION, SIZE_A, PRICE_A1, PRICE_A2 SIZE_B, PRICE_B1, PRICE_B2 SIZE_C, PRICE_C1, PRICE_C2 FROM ProductTable ORDER BY SPECIES </CFQUERY> Thanks in advance... Kent NB: This email and any attachments have been checked for the presence of computer viruses using McAfee's Anti-Virus Protection technology. None were found. --------------------------------------------------------------------- Imagenet Tel: 513-561-2328 http://www.imagenet2000.com Sales Email: [EMAIL PROTECTED] Support Email: [EMAIL PROTECTED] This message is confidential and intended solely for the use of the addressee. Quotations are subject to contract and valid for 28 days. ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
