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
Hi Hatton,
Here is an example of my code:
cfloop index=PType list=#FORM.PropertyType# delimiters=,
cfquery name=SearchProperties datasource=CMSX
SELECT PropertyID,
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
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
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
5 matches
Mail list logo