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,

RE: Using CFmail and loops

2002-01-25 Thread C. Hatton Humphrey
PROTECTED]] > Sent: Friday, January 25, 2002 11:12 AM > To: CF-Talk > Subject: Using CFmail and loops > > > Hi, > > I am having a serious problem with CFMAIL. > > I have a form that has a collection of checkboxes, about nine of > them, the user can select any one of t

Using CFmail and loops

2002-01-25 Thread Stephen Adams
Hi, I am having a serious problem with CFMAIL. I have a form that has a collection of checkboxes, about nine of them, the user can select any one of them or as many as they want. This form also contain some other details that the user fills in. When they submit this form a search is carrie