Hi,
I wish to combine a numeric field with a varchar field into a single field
withing a Query of Query.
eg 12358989 + '123456X' = 12358989123456X
The error I get is :
Query Of Queries runtime error.
Cannot mix types "BIGDECIMAL" and "VARCHAR" in a "+" binary operation.
SQL:
<cfquery dbtype="query" name="ECG_LOAD">
SELECT
PRVSP_REFNO + SERVICING_PROVIDER_NO AS GROUPING,
*
FROM
OUTPATIENT_LOAD
WHERE
TRANSACTION_TYPE = 'ECG'
ORDER BY
PRVSP_REFNO
</cfquery>
Scott Thornton, Programmer
Application Development
Information Services and Telecommunications
Hunter-New England Area Health Service
Phone RNH +61 2 49236066
Fax +61 2 49236076
[EMAIL PROTECTED]
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
