use multiple cold fusion query - and output it in the same table
how can i use multiple query and show it in the same table?
i am using cold fusion query and mssql database.
BELOW IS MY CODE WHICH RUNS CORRECTLY, BUT ONLY USE 1 QUERY.
my code:
var myData = [<cfoutput query="qSearch">["#qSearch.CurrentRow#","<A href='myform.cfm?RefNo=#ID#' target='_blank'>#ID#</a>","#TITLE#","#TYPE#","#COMMENT#","#DATE#","#ACTIONSTATUS#"],</CFOUTPUT>];
var columnTitles = new array();
columnTitles.add("ID", "MY<br>TITLE", "TYPE", "COMMENT", "DATE", "STATUS");
i am confused. anybody knows how? thanks.
i am using cold fusion query and mssql database.
BELOW IS MY CODE WHICH RUNS CORRECTLY, BUT ONLY USE 1 QUERY.
my code:
var myData = [<cfoutput query="qSearch">["#qSearch.CurrentRow#","<A href='myform.cfm?RefNo=#ID#' target='_blank'>#ID#</a>","#TITLE#","#TYPE#","#COMMENT#","#DATE#","#ACTIONSTATUS#"],</CFOUTPUT>];
var columnTitles = new array();
columnTitles.add("ID", "MY<br>TITLE", "TYPE", "COMMENT", "DATE", "STATUS");
i am confused. anybody knows how? thanks.
ellisegirl
April 3,