I have tried this: ... PROFESSIONAL.PROFESSIONAL_USER = <cfqueryparam value="#FileMgmtUser#" cfsqltype="CF_SQL_VARCHAR" maxlength="6"> ...
and get the same error >>> [EMAIL PROTECTED] 8/10/2003 4:19:21 pm >>> 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/ ---------------------------------------------------------------------- Maddocks Melbourne - Tel: (61 3) 9288 0555 Fax: (61 3) 9288 0666 Sydney - Tel: (61 2) 8223 4100 Fax: (61 2) 9221 0872 Web: http://www.maddocks.com.au ---------------------------------------------------------------------- The information in this electronic mail is privileged and confidential, intended only for use of the individual or entity named. If you are not the intended recipient, any dissemination, copying or use of the information is strictly prohibited. If you have received this transmission in error please delete it immediately from your system and inform us by email on [EMAIL PROTECTED] ---------------------------------------------------------------------- --- 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/
