Quoting Antony Sideropoulos <[EMAIL PROTECTED]>: > SELECT MATTER.CLIENT_CODE, MATTER_CODE, MATTER_DESC, LAST_TIME_DATE, > LAST_DISB_DATE, LAST_DISB_BILL_DATE, LAST_FEES_BILL_DATE, WIP_AMOUNT, > UNBILLED_DISB, SHORT_NAME,UNBILLED_COSTING, > MATTER.TRUST_CLEAR_COMMITTED > FROM MATTER, CLIENT, PROFESSIONAL > WHERE PROFESSIONAL.PROFESSIONAL_USER = '#MgmtUser#' AND ARCHIVE_STATUS > = 0 AND MATTER.CLIENT_CODE = CLIENT.CLIENT_CODE AND > MATTER.PARTNER_RESPONSIBLE_CODE = PROFESSIONAL.PROFESSIONAL_CODE > ORDER BY STD_NAME_LINE_1, MATTER_CODE DESC
Try using a cfqueryparam (which you should be doing anyway). I think you will find it will work. Mark ------------------------------------------------------------------ [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [ www.safefrombees.com ] --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
