Re: RE: Using CFmail and loops

[Stephen Adams]

Hi Hatton,

Here is an example of my code:

<cfloop index="PType" list="#FORM.PropertyType#" delimiters=",">
                
                <cfquery name="SearchProperties" datasource="CMSX">
                
                        
                        SELECT  PropertyID,
                                        FullJobName,
                                        PropertyType,
                                        Tenure
                        FROM            Properties
                        WHERE   PropertyType = '#FORM.PropertyType#' 
                
                        <cfif IsDefined("FORM.PropertyInfo")>
                                
                                <cfif FORM.PropertyInfo NEQ "Freehold,Leasehold">
                                
                                        AND             Tenure = '#FORM.PropertyInfo#'
                                
                                </cfif>
                                
                        </cfif>
                
                        AND                     OnPrintedList = 1
                        ORDER BY                PropertyType, 
                                                FullJobName,
                                                Tenure
                                                
                        
                        
                </cfquery>
                
        <cfmail query="SearchProperties"
                                to="[EMAIL PROTECTED]"
                                from="[EMAIL PROTECTED]"
                                server="mail.company.com"
                                port=25
                                timeout=20
                                type="HTML">
                
                <cfloop query="SearchProperties">

                        <cfoutput>
                                <p>
                                <table>
                                        
<tr><td>#SearchProperties.FullJobName#</td></tr>
                                        
<tr><td>#SearchProperties.PropertyType#</td></tr>
                                        <tr><td>#SearchProperties.Tenure#</td></tr>
                                </table>
                                </p>
                                <hr>
                        </cfoutput>
                
                </cfloop>
                
                        
        </cfmail>
        
        </cfloop>

Hope this helps,

Cheers Stephen




______________________________________________________________________
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists