What you have is a variable inside of a variable.
When you are doing your <cfoutput> you are only evaluating the first
variable, which displays the second variable but doesn't evaluate it.
Try:
<cfoutput>
#Evaluate(getheader.mainheader)#
</cfoutput>
You might get an error about nested <cfoutput>s if you don't remove the set
from the varchar first. I don't know if this will work (untested), but it
seems logical.
Todd
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 19, 2000 7:19 PM
Subject: Where did the CF Code dissappear?
>
> Probably simple, just never had a reason to try it
> until now. I want to put CF code in a text area.
> insert it to a varchar field in SQL 7 then output
> the CF code to an html page. BUT!! It disappears.
> Simplified---------
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
>
> <html>
> <head>
> <title>Untitled</title>
> </head>
>
> <body>
> <cfquery name="getheader" datasource="#default_datasource#">
> Select mainheader
> from styles
> where styleID = 1
> </cfquery>
> <cfoutput>
> #getheader.mainheader#
> </cfoutput>
>
> </body>
> </html>
> This is what is in the mainheader varchar field.----------
> <cfoutput>#qryincome.income#</cfoutput><table
border=1><tr><td>test</td></tr></table>
> ---------
> The table come out fine but the only thing that shows from the <cfoutput>
on the webpage is
> --- #qryincome.income# ------
>
> Viewing the source code on the page I see this. After removing the <table>
> -------------
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
>
> <html>
> <head>
> <title>Untitled</title>
> </head>
> <body>
> <cfoutput>#getheader.mainheader#</cfoutput>
>
> </body>
> </html>
>
> Copy the code paste it into a new page and voila.
> It works.
>
> SOOO?? What is happening here?? What am I missing?
------------------------------------------------------------------------------
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.
