When displaying an error, it simply displays the text that crashed.. since
it's html, it's passing the html to the page, which is interpreted by the
browser (not CF). If you do a view source, you will see that all your html is
there.
The problem isn't the format: CF/SQL only know it as text; they don't
interpret it as HTML. So you've either got a problem with length, or there's
something in there that SQL doesn't like (for example, some character that
needs to be escaped out). What's the SQL error? What does the query look
like?
However, to answer your question, you can use HTMLEncode(string) to output
html without it being rendered; however, this is only for output, as has
nothing to do with SQL (don't use it in your query). You should change your
track of thinking in debugging this issue.
--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]
David Shuck wrote:
> I am trying to insert a chunk of html code from <html> to </html> into a
> field in a DB. The sql works in a query tool, but fails in CF. In the
> error debugging on the page where it shows the query, it displays the html
> like it would if it was outputting it on a page after 'values'. I am
> assuming that CF is trying to interpret it rather than just consider it a
> long string of text. I know there is some way to let CF know that it is
> just raw text, but I am drawing a major blank. Anyone?
>
> Thanks.
>
> ~Dave
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
