oops .. sorry, yes, I was doing that already ... left it out of my message.
>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/cf-talk@houseoffusion.com/
>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/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
--
___________________________________________________________________________
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists