yes - the same code works in a CF5 page pointing to the same oracle database
>>> [EMAIL PROTECTED] 8/10/2003 4:41:39 pm >>> 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/ ---------------------------------------------------------------------- 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/
