Has anyone seen the following error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Oracle][ODBC]String data, right truncated.
ColdFusion MX 6.1, Oracle 8 database The query: 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 The variable MgmtUser is definitely being set; it makes no difference if I hard-code a value in the query - same error. THe same query works on a CF5 webpage talking to the same Oracle database. Any ideas? ---------------------------------------------------------------------- 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/
