D
drummer99
Guest
I am trying to include an approval list in the body of a Mailto message. I can get the first name, but it won't continue to search.
The query works outside of the Mailto, so it is just a matter of getting the CFLOOP tag in the right place, I think.
Here is the code. Any suggestions?
<cfif isDefined("URL.Brand_New") AND URL.Brand_New EQ 1><cfoutput><A HREF="mailto:#QS_DOC_Find.ORIGINATOR#?subject=New Document Number #QS_DOC_Find.Code#&body=Here is the number you requested: #QS_DOC_FIND.Code# #QS_DOC_Find.Title#
PTN signoff will be yourself and:<cfloop query="signoff_lookup"> #signoff_lookup.FIRST_NAME# #signoff_lookup.LAST_NAME# #signoff_lookup.SIGN_TITLE#" </cfloop>
onBlur="placeFocus();"><img src="images/mail.jpg" border="0" width="14" height="11" alt="Notify this User of their New Document"></a></cfoutput></cfif>
The query works outside of the Mailto, so it is just a matter of getting the CFLOOP tag in the right place, I think.
Here is the code. Any suggestions?
<cfif isDefined("URL.Brand_New") AND URL.Brand_New EQ 1><cfoutput><A HREF="mailto:#QS_DOC_Find.ORIGINATOR#?subject=New Document Number #QS_DOC_Find.Code#&body=Here is the number you requested: #QS_DOC_FIND.Code# #QS_DOC_Find.Title#
PTN signoff will be yourself and:<cfloop query="signoff_lookup"> #signoff_lookup.FIRST_NAME# #signoff_lookup.LAST_NAME# #signoff_lookup.SIGN_TITLE#" </cfloop>
onBlur="placeFocus();"><img src="images/mail.jpg" border="0" width="14" height="11" alt="Notify this User of their New Document"></a></cfoutput></cfif>