try
INSERT INTO MyTable (Link) VALUES ('#MyLink#');
-----Original Message-----
From: Joseph J. Sanger, M.D. [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 25, 2000 10:02 AM
To: CF-Talk
Subject: Inserting HTML Anchor into Oracle
I am trying to insert a record with the following text into Oracle:
<CFSET MyLink='<A HREF="TheLink">SomeText</A>'>
with the following CF statement:
INSERT INTO MyTable (Link) VALUES (#MyLink#);
The code executes without an error message, but no insertion occurs.
With debugging turned on, I can see the insert statement ... it looks
fine, and if I copy and paste it directly into SQL*Plus, it actually
DOES the insert without a burp.
So there is something that CF doesn't like about the #MyLink#
contents ... I suspect it is related to the double quotes or the <
or > characters. Can anyone help? Thanks ... I have been stuck on
this for hours ....
--
___________________________________________________________________________
Joseph J. Sanger, M.D. | Phone: (212) 263-7410
Associate Professor of Clinical Radiology | Fax: (212) 263-2039
Director, Division of Radiology Informatics |
Director, Software Development |
Co-Director, Division of Nuclear Medicine |
Co-Director, Nuclear Cardiology |
New York University School of Medicine | [EMAIL PROTECTED]
___________________________________________________________________________
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
