RE: RE: Using CFmail and loops

2002-01-25 Thread C. Hatton Humphrey
Original Message- > From: Billy Cravens [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 25, 2002 12:40 PM > To: CF-Talk > Subject: Re: RE: Using CFmail and loops > > > Actually, it might be a bit cleaner to use the ListQualify > function instead > of Replace: &

Re: RE: Using CFmail and loops

2002-01-25 Thread Billy Cravens
anuary 25, 2002 11:15 AM Subject: RE: RE: Using CFmail and loops > Stephen, > > You should be able to re-work your query to use the in function (where > PropertyType IN ('#replace(form.propertytype, ",", "','", "ALL")#'). > > Al

RE: RE: Using CFmail and loops

2002-01-25 Thread C. Hatton Humphrey
Stephen, You should be able to re-work your query to use the in function (where PropertyType IN ('#replace(form.propertytype, ",", "','", "ALL")#'). Also, you might try building a pseudo grouping into your loop inside the cfmail and take out the query parameter of the cfmail tag assuming tha

Re: RE: Using CFmail and loops

2002-01-25 Thread Stephen Adams
Hi Hatton, Here is an example of my code: SELECT PropertyID, FullJobName, PropertyType,