returns(which I need). Has anyone else seen this, known thing?
Example:
<cfquery name="mainQuery" DATASOURCE="#app_datasource#" USERNAME="#app_user#"
PASSWORD="#app_passwd#">
select text1
from myView
where key = 100
</cfquery>
<cfquery dbtype="query" name="subQuery">
select text1
from mainQuery
where detail_key = 1
</cfquery>
<cfquery name="mainQuery2" DATASOURCE="#app_datasource#" USERNAME="#app_user#"
PASSWORD="#app_passwd#">
select * from myView
where detail_key = 1
</cfquery>
<cfoutput>
<hr>
#replace(subQuery.text1,Chr(13),"<BR>","ALL")#
<hr>
#replace(mainQuery2.text1,Chr(13),"<BR>","ALL")#
<hr>
</cfoutput>
HTML Result:
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
