I've got a oracle db query that returns a recordset with an amount column which can sometimes be a negative value. I then have a QofQ to extract a portion of data that uses SUM(amount)...It appears to be ignoring the fact that some amounts are negative and it's giving me a total as if they're all positive. Am I missing sumthin? (CF5 here)
Appreciate any insight! Stace Stacy Young System Integration Specialist, Architecture Need Payment Processing? Goto the source! Surefire Commerce http://www.sfcommerce.com <http://www.sfcommerce.com> (p) 514-380-2700 ext: 3234 (f) 514-380-2760 AVIS IMPORTANT: ------------------------------- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: ------------------------------- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
