<CFOUTPUT> in <CFSCRIPT> 1

[KevinFSI]

You know, I pretty much do everything in <CFSCRIPT> these days. All my CFIF, CFSWITCH, CFLOOP, CFSET, etc... are inside CFSCRIPT tags. It's just personal preference, but I can't seem to figure out a way to say

<CFOUTPUT QUERY=&quot;myQuery&quot;>...</CFOUTPUT>

in a <CFSCRIPT> tag.

Can it be done? Kevin
slanek@ssd.fsi.com

 

[CFHub]

WriteOutput('your text' & A_Variable);

 

[KevinFSI]

That's not quite what I'm asking. That only works if I've placed <CFOUTPUT> tags OUTSIDE the <CFSCRIPT>. I'm wanting to know if I can output a query from INSIDE the <CFSCRIPT>. Kevin
slanek@ssd.fsi.com

 

[tleish]

Simply treat the query as an Array of Structures:

<CFSCRIPT>
for(i=1; i LTE qQueryName.RecordCount; i=i+1){
WriteOutput(qQueryName.ColumnName

[

i

]

& &quot;<BR>&quot;
}
</CFSCRIPT> - tleish

 

[KevinFSI]

Hey, there you go. That's exactly what I was looking for! Kevin
slanek@ssd.fsi.com