RE: Using CFmail and loops

2002-01-25 Thread C. Hatton Humphrey
Can you post a code snippet to show us an idea of what you're doing? Without seeing any, the suggestion might be to use CFParam to define your form checkboxes and in your SQL statement, use the IN (#form.fieldname#) as opposed to looping through a list. You'll need to make sure the formfield is

Re: RE: Using CFmail and loops

2002-01-25 Thread 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,

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 that you

Re: RE: Using CFmail and loops

2002-01-25 Thread Billy Cravens
Actually, it might be a bit cleaner to use the ListQualify function instead of Replace: listQualify(form.propertyType,') - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 25, 2002 11:15 AM Subject: RE: RE: Using CFmail

RE: RE: Using CFmail and loops

2002-01-25 Thread C. Hatton Humphrey
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: listQualify(form.propertyType,') - Original Message - From: C. Hatton Humphrey [EMAIL