Have you checked that MATTER.CLIENT_CODE is defined the same as CLIENT.CLIENT_CODE, and that MATTER.PARTNER_RESPONSIBLE_CODE is defined the same as PROFESSIONAL.PROFESSIONAL_CODE
Phil. ----- Original Message ----- From: "Antony Sideropoulos" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, October 08, 2003 3:53 PM Subject: [cfaussie] SQL Error: String data, right truncated. > 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/ > --- 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/
