Try:
SELECT
image_title,
'http://www.hello.com/empower/global/' || filename AS image_location
FROM
images
ORDER BY
image_title
Arve
-----Original Message-----
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: 31. august 2000 19:58
To: CFTalk
Subject: Oracle Concatenation???
Hi All,
The following SQL string concatenation in Oracle is producing an error
SELECT
image_title,
'http://www.hello.com/empower/global/' + filename AS image_location
FROM
images
ORDER BY
image_title
Error Occurred While Processing Request
Error Diagnostic Information
Oracle Error Code = 1722
ORA-01722: invalid number
What is the correct method of concatenating strings in Oracle?
TIA,
Duane Boudreau,
eMPower Project Manager
Director, Web Technologies
Ektron, Inc.
http://www.ektron.com
5 Northern Blvd, Suite 6
Amherst, NH 03031
Tel: 603-594-0249 x114
Fax: 603-594-0258
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
