This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C013B1.29504740
Content-Type: text/plain;
charset="iso-8859-1"
Replace the '+' with '||'.
-----Original Message-----
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 10:58 AM
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.
------_=_NextPart_001_01C013B1.29504740
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2651.75">
<TITLE>RE: Oracle Concatenation???</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Replace the '+' with '||'.</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Duane Boudreau [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</F=
ONT>
<BR><FONT SIZE=3D2>Sent: Thursday, August 31, 2000 10:58 AM</FONT>
<BR><FONT SIZE=3D2>To: CFTalk</FONT>
<BR><FONT SIZE=3D2>Subject: Oracle Concatenation???</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi All,</FONT>
</P>
<P><FONT SIZE=3D2>The following SQL string concatenation in Oracle is =
producing an error</FONT>
</P>
<P><FONT SIZE=3D2>SELECT</FONT>
<BR> <FONT =
SIZE=3D2>image_title,</FONT>
<BR> <FONT SIZE=3D2>'<A =
HREF=3D"http://www.hello.com/empower/global/'" =
TARGET=3D"_blank">http://www.hello.com/empower/global/'</A> + filename =
AS image_location</FONT>
<BR><FONT SIZE=3D2>FROM</FONT>
<BR> <FONT =
SIZE=3D2>images</FONT>
<BR><FONT SIZE=3D2>ORDER BY</FONT>
<BR> <FONT =
SIZE=3D2>image_title</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Error Occurred While Processing Request</FONT>
<BR><FONT SIZE=3D2>Error Diagnostic Information</FONT>
<BR><FONT SIZE=3D2>Oracle Error Code =3D 1722</FONT>
</P>
<P><FONT SIZE=3D2>ORA-01722: invalid number</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>What is the correct method of concatenating strings =
in Oracle?</FONT>
</P>
<P><FONT SIZE=3D2>TIA,</FONT>
<BR><FONT SIZE=3D2>Duane Boudreau,</FONT>
<BR><FONT SIZE=3D2>eMPower Project Manager</FONT>
<BR><FONT SIZE=3D2>Director, Web Technologies</FONT>
<BR><FONT SIZE=3D2>Ektron, Inc.</FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://www.ektron.com" =
TARGET=3D"_blank">http://www.ektron.com</A></FONT>
<BR><FONT SIZE=3D2>5 Northern Blvd, Suite 6</FONT>
<BR><FONT SIZE=3D2>Amherst, NH 03031</FONT>
<BR><FONT SIZE=3D2>Tel: 603-594-0249 x114</FONT>
<BR><FONT SIZE=3D2>Fax: 603-594-0258</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
---------------</FONT>
<BR><FONT SIZE=3D2>Archives: <A =
HREF=3D"http://www.mail-archive.com/[email protected]/" =
TARGET=3D"_blank">http://www.mail-archive.com/[email protected]/=
</A></FONT>
<BR><FONT SIZE=3D2>To Unsubscribe visit <A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk</A> or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01C013B1.29504740--
------------------------------------------------------------------------------
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.
