Cool! I probably don't need to mess with it, but it's good to know anyway.
Thanks again,
Matthieu
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 27, 2002 9:20 AM
To: CF-Talk
Subject: Re: escaping ampersands in sql*plus
You can a
You can also change the escape character using the set command in SQL Plus.
The \ is the default, but if you do something like
SET ESCAPE (your new symbol here) ON
The escape character will be your new symbol.
Not positive on the syntax on that, though.
-d
Deanna Schneider
Interactive Media
sands in sql*plus
Matthieu,
Do this before your code:
SET ESCAPE ON
then this
INSERT INTO DEPARTMENTS
VALUES (1,2,3,'Mergers \& Acquisitions');
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
__
Matthieu,
Do this before your code:
SET ESCAPE ON
then this
INSERT INTO DEPARTMENTS
VALUES (1,2,3,'Mergers \& Acquisitions');
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
__
Structure your ColdFusion code
Have you tried ? That usually scrubs the data for you...
-Original Message-
From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 26, 2002 3:07 PM
To: CF-Talk
Subject: OT: escaping ampersands in sql*plus
Hi. I know that the ampersand (&) character, whe
Cornillon, Matthieu wrote:
> Hi. I know that the ampersand (&) character, when in an insert statement in
> SQL*PLUS, causes a problem, because it's a special character. I am guessing
> that there is a way to escape this out, but I can't figure it. Here is the
> statement:
>
> INSERT INTO DEPAR
Hi. I know that the ampersand (&) character, when in an insert statement in
SQL*PLUS, causes a problem, because it's a special character. I am guessing
that there is a way to escape this out, but I can't figure it. Here is the
statement:
INSERT INTO DEPARTMENTS
VALUES (1,2,3,'Mergers & Acquisi
7 matches
Mail list logo
