WHAT'S WRONG WITH THE FOLLOWING SOURCE ??
<CFQUERY NAME="GetQTask" DATASOURCE="eKong">
Select * from QTask where wStatus ='P'
</CFQUERY>
<cfmail query="GetQTask"
FROM="tonychan@algoltec.com"
TO="#GetQTask.EMail#"
SERVER="192.168.1.254"
PORT="25"
SUBJECT="#GetQTask.ESubject#">
#GetQTask.content# <BR><BR>
<CFDIRECTORY action="list" directory="#APPLICATION.DATAPATH##UQ1.TemplateName#\html\"
FILTER="*.*" name="dircontents">
<CFIF dircontents.RecordCount GT 0>
<cfoutput query="dircontents">
<CFIF len(dircontents.name) GT 2>
<cfinclude TEMPLATE="#APPLICATION.DATAPATH##UQ1.TemplateName#\html\#dircontents.name#" >
</CFIF>
</cfoutput>
</cfif>
</cfmail>
I GOT THIS ERROR MESSAGE :
A query driven CFOUTPUT tag is nested inside a CFMAIL tag that also has a QUERY= attribute. This is not allowed. Nesting these tags implies that you want to use grouped processing. However, only the top-level tag can specify the query that drives the processing.
CAN I DEFINE QUERY INSIDE THE <cfmail> TAG ????
THANKS IN ADVANCE....
<CFQUERY NAME="GetQTask" DATASOURCE="eKong">
Select * from QTask where wStatus ='P'
</CFQUERY>
<cfmail query="GetQTask"
FROM="tonychan@algoltec.com"
TO="#GetQTask.EMail#"
SERVER="192.168.1.254"
PORT="25"
SUBJECT="#GetQTask.ESubject#">
#GetQTask.content# <BR><BR>
<CFDIRECTORY action="list" directory="#APPLICATION.DATAPATH##UQ1.TemplateName#\html\"
FILTER="*.*" name="dircontents">
<CFIF dircontents.RecordCount GT 0>
<cfoutput query="dircontents">
<CFIF len(dircontents.name) GT 2>
<cfinclude TEMPLATE="#APPLICATION.DATAPATH##UQ1.TemplateName#\html\#dircontents.name#" >
</CFIF>
</cfoutput>
</cfif>
</cfmail>
I GOT THIS ERROR MESSAGE :
A query driven CFOUTPUT tag is nested inside a CFMAIL tag that also has a QUERY= attribute. This is not allowed. Nesting these tags implies that you want to use grouped processing. However, only the top-level tag can specify the query that drives the processing.
CAN I DEFINE QUERY INSIDE THE <cfmail> TAG ????
THANKS IN ADVANCE....